Federated Queries

One SQL engine to query your entire data estate

One query joins Postgres, Snowflake, BigQuery and the rest of your sources including APIs and streams. The result feeds a feature, a training set or an agent's tool call. Chalk queries each source in place, at inference time or in bulk.

hero gradient
Whatnot logo
Socure logo
Sunrun logo
Grindr logo
Turo logo
MoneyLion logo
Melio logo
Mission Lane logo
Medely logo
Iwoca logo
Nowsta logo
Apartment List logo
Pipe logo

Explore Chalk Federated Queries

One query, many systems

Join Postgres with BigQuery in a single query.

Over 10 leading source types

Postgres, DynamoDB, MySQL, Iceberg, ClickHouse, BigQuery, Turbopuffer, Redshift, Snowflake, Databricks and more. Anything else with Python.

Attach a catalog inline

Attached catalogs are read-only and scoped to the session. No connection opens until you run a query against it.

Python-powered views

Write Python that pulls from a REST API, an S3 bucket or a SaaS app, and access its output as a table in the same query as your sources.

SQL-driven feature definition

Pass Chalk SQL to online and offline runs without input lists or intermediate exports.

Explore what’s available

Review every registered source, schema and view with SQL Explorer.

company logo

We're moving hundreds of millions of features per second, each payload around 1MB, and still hitting a P99 latency of just 100ms. That kind of performance across the board is a real testament to the system Chalk built.

Emmanuel Fuentes
Emmanuel FuentesVP, Data & AI at Whatnot

How Federated Queries work

Register your sources

Each database and warehouse you register becomes a catalog you can browse.

Chalk Catalog Components

Write one query across them

The datasource name is the catalog name, so the join reads normally.

What is ChalkSQL

Use it as an input

Pass Chalk SQL directly to a feature query or training run. Chalk dynamically resolves it without intermediate exports.

SQL as Input

Query every source where it already lives

Most data platforms require a migration to work. Chalk registers every source where it is and queries it in place at inference time.

WHAT IS CHALKSQL
product section resource

Keep up with Chalk

What we've been up to and where to find us next.

Query across your systems without moving them

Talk to an engineer about consolidating your data reads for models and agents.