Skip to main content
SQL gives you one read-only surface for the data available to a Workspace. Connect a SQL tool such as DBeaver, or a Flight SQL client SDK, to query tables from Providers, published files, materialized Plots, and live Workspace metadata without copying them into a separate query system.

​
Choose what to query

Provider quality is a companion catalog at providers_quality. It describes the health of Provider tables; it is not another data pool. Bronze, Silver, and Gold are not part of this SQL surface. They are storage and processing details behind the logical tables above. Every read of a Provider table follows the Workspace’s Provider Policies: your roles decide which of its rows you read, and a table hidden from them reads as empty.

​
Run your first query

  1. Get a role that can query, create a SQL token, and connect DBeaver or Python: Query Provider Pools with SQL walks through each step. For Go and Rust, see Query with SDKs.
  2. Discover your Workspace’s tables and columns.
  3. Use fully qualified table names in a read-only SQL statement.
The Workspace selected on the request determines which tables you can see. A catalog name never contains the Workspace slug. Your role decides which pools you reach. The Provider Pools Reader role queries the Provider Pool, its quarantine, and Provider quality. The Data Access and Workspace Administrator roles query every pool.

​
Learn the contract

Data catalog

Understand pools, discover tables, and find the source of each table.

SQL behavior

Learn naming, types, relationships, and supported operations.

Query Provider Pools

Create a SQL token and connect DBeaver or Python.

Flight SQL

Use the underlying Arrow Flight SQL protocol directly.

Query Provider Pools with SQL

Create a SQL token, connect DBeaver or Python, and run your first query against your Workspace's Provider Pools.

Query with SDKs

Execute Workspace SQL with Python, Go, or Rust Flight SQL clients.

Flight SQL

Connect an ADBC, JDBC, or custom client to Parable's read-only Workspace data through Arrow Flight SQL.

Data Catalog

Discover Tables and Columns

Inspect Workspace catalogs, schemas, tables, columns, and semantic annotations before writing SQL.

Search Available Data

Find the tables, columns, and fields that hold the data a question needs with search_available_data, a search of the Workspace and Provider Pools by keyword and, where it is configured, by meaning.

Provider Pool

Query and join the current data supplied by Provider Plugins.

Artifact Pool

Query files that a Workspace has published as SQL tables.

Parable Pool

Query materialized Plot results by Parable and Plot slug.

Workspace Pool

Query live Workspace membership, Provider, role, Parable, Plot, and run metadata.

Provider Quality

Query checks, statistical process control, shape, and health for Provider tables.

SQL Behavior

Fully Qualified Names

Address SQL pools, schemas, tables, flattened fields, and child tables precisely.

Types and Metadata

Interpret Arrow field types, semantic scalar annotations, and Parable catalog metadata.

Keys and Relationships

Discover logical primary keys, foreign keys, and safe relationships between SQL tables.

Supported Operations

Check the supported read-only SQL, prepared statement, and metadata operations.