ClickHouseAditya Chidurala, José Muñoz, Alex Francoeur8 min readintermediate
ClickHouse is now available on the dbt platform
Summary
ClickHouse released a public‑beta dbt v2 adapter written in Rust that ships inside the dbt binary and talks to ClickHouse via the new ADBC driver. The adapter promises up to 30× faster dbt parsing and leverages ClickHouse’s sub‑second, high‑concurrency engine (e.g., materialized views, MCP server). A private‑beta integration on the dbt Platform now lets users develop, schedule, and catalog ClickH…
- Rust‑based dbt v2 adapter is bundled with the dbt binary; no separate pip package needed.
- Connectivity uses the ClickHouse ADBC driver (Apache Arrow) and is auto‑downloaded on first use.
- Public beta (Sept 16 2026) – still missing some v1 features; test coverage ~81 % of dbt v1 suite, 92 % for ClickHouse‑specific tests.
- Performance claims: dbt parse times up to 30× faster; ClickHouse Cloud 412× better real‑time performance‑per‑dollar vs Snowflake (42 ms P99 latency on aggregate queries).
Bringing ClickHouse into dbt v2 and the dbt Platform gives data teams a single, open‑source stack for both ELT model definition and sub‑second analytics, enabling real‑time dashboards and AI agents to query fresh data without the latency of traditional batch warehouses.
6/10
