Loading post…
ClickhouseAnnouncement
ClickHouse is now available on the dbt platform
Summary
The ClickHouse adapter for dbt v2, dbt’s Rust rewrite, entered public beta on September 16, 2026, while ClickHouse became a natively supported data warehouse on the dbt platform in private beta. The v2 adapter ships inside the open-source dbt binary, connects through an ADBC driver using Apache Arrow, and supports both open-source ClickHouse and ClickHouse Cloud. Existing models, tests, and profiles carry over, although some features remain incomplete and dbt plans to support the v1 and v2 adapters in parallel. The platform integration provides ClickHouse connections for Studio, environments, scheduled jobs, and Catalog, while the planned path to general availability includes parity items such as ON CLUSTER DDL and distributed materializations, followed by Fusion capabilities.
Context
The announcement follows five years of dbt and ClickHouse integration. The community-supported dbt-clickhouse adapter has more than 2,000 production teams and remains generally available alongside the new v2 adapter and the dbt platform’s private-beta integration.
Approach / What changed
The v2 adapter rebuilds the ClickHouse integration for dbt’s Rust engine, embeds it in the dbt binary, and connects through the ClickHouse ADBC driver using Apache Arrow. The dbt platform exposes ClickHouse as a connection for Studio, environments, scheduled jobs, and Catalog, while the teams gather feedback and work toward feature parity with the v1 adapter.
Takeaways
The v2 adapter is installed through the pre-release dbt binary rather than as a separate package; it downloads the ClickHouse ADBC driver on first use.
The existing Python dbt-clickhouse adapter remains generally available and maintained, while the v2 adapter is in public beta and the dbt platform integration is in private beta.
The path to general availability includes ON CLUSTER DDL and distributed materializations, followed by planned Fusion capabilities such as dialect-aware validation, static analysis, a language server, and column awareness in VS Code.
FAQ
What changes when moving from the dbt v1 adapter to the v2 adapter?
The v1 adapter is a standalone Python package, while the v2 adapter is built into the dbt binary and uses ADBC to connect to ClickHouse. Models, tests, and profiles carry over, but some features are still missing, so the v1-versus-v2 parity table should be reviewed.
Can the adapter connect to both ClickHouse Cloud and self-managed ClickHouse?
Yes. The v2 adapter targets the same ClickHouse engine for open-source ClickHouse on users’ hardware, ClickHouse Cloud, and BYOC inside a user’s own account.
What ClickHouse capabilities are supported by the existing adapter?
The maintained adapter supports table, view, incremental, and microbatch materializations, seeds, snapshots, contracts, and data and unit tests. It also supports ClickHouse-specific materializations for materialized views, dictionaries, and distributed tables, plus settings such as sorting keys, codecs, TTLs, skipping indexes, and projections.
Source and freshness
- Source
- clickhouse.com
- Published
- Added to Yomu
Summaries are generated from the original by a language model. Check the original before relying on it.
Keep reading
Related reading
The Good Stuff
Paid picks we use ourselves. Links carry a referral code — a subscription through one earns us a commission at no extra cost to you.
The best engineering reads, once a week
One useful email. Unsubscribe anytime.