dbt-clickhouse
The Clickhouse plugin for dbt (data build tool)
Decision gist · record as of 2026-08-14
Yes. The adapter is production-stable (Development Status 5), actively maintained with a release on 2026-08-13, has no known vulnerabilities, and supports current Python versions (3.10–3.13). Install it if you use ClickHouse and want to adopt dbt for data transformation. Be aware that dbt Cloud integration is not yet available, and Catalog integrations require workarounds.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later; dbt-core and dbt-adapters must be installed separately (v1.8+); ClickHouse server must be accessible with valid credentials.
- Low friction installation as a pure Python wheel.
- Actively maintained with a release within the last day and recent commits.
License · maintenance · safety
Apache-2.0 (permissive) — Apache-2.0 permissive license allows commercial and private use with minimal restrictions, suitable for most production environments.
last release 2026-08-13 (1 days) · last repo commit 2026-08-13 · 357 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 2,520,131 downloads/mo, #3,025 on PyPI
Alternatives
Verify before relying
pip install dbt-core dbt-clickhouse
from dbt.adapters.clickhouse import ClickhouseAdapter
# Configure via dbt profiles.yml with ClickHouse connection details- Whether Catalog integrations (e.g., Iceberg) workarounds are production-ready or experimental
- Performance characteristics on large-scale incremental and distributed materializations
- Compatibility with dbt Cloud (documentation states not yet available)
What it is and what it does
dbt-clickhouse is a dbt adapter that brings dbt's data transformation and testing capabilities to ClickHouse databases. It translates dbt's model definitions, tests, and documentation workflows into ClickHouse-native SQL, enabling version-controlled, modular data pipelines on ClickHouse. The adapter supports standard dbt materializations (tables, views, incremental models) and adds ClickHouse-specific features like materialized views, distributed tables, and custom column codecs and TTL settings.
You install it alongside dbt-core and dbt-adapters, configure a ClickHouse connection in your dbt profiles, and then write dbt models in SQL or YAML. The adapter handles compilation, testing, documentation generation, and snapshots. It supports most dbt-utils macros and covers dbt-core features up to version 1.10, though Catalog integrations remain experimental.
Use it for
- Build modular, version-controlled data pipelines in ClickHouse using dbt's model and macro framework.
- Run automated data quality tests and generate documentation for ClickHouse tables and transformations.
- Implement incremental and microbatch loading patterns to efficiently update large ClickHouse datasets.
- Configure ClickHouse-specific optimizations (indexes, projections, codecs, TTL) directly in dbt model definitions.
- Manage distributed table materializations and transformations across ClickHouse cluster nodes.
- Snapshot and track historical changes in ClickHouse tables using dbt's snapshot functionality.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
The adapter is production-stable (Development Status 5), actively maintained with a release on 2026-08-13, has no known vulnerabilities, and supports current Python versions (3.10–3.13). Install it if you use ClickHouse and want to adopt dbt for data transformation. Be aware that dbt Cloud integration is not yet available, and Catalog integrations require workarounds.
Install
dbt-clickhouse on PyPI
Before you install
Low friction installation as a pure Python wheel. Actively maintained with a release within the last day and recent commits. Requires dbt-core and dbt-adapters as separate dependencies since v1.8, and two ClickHouse client libraries (clickhouse-connect and clickhouse-driver).
Requires Python 3.10 or later; dbt-core and dbt-adapters must be installed separately (v1.8+); ClickHouse server must be accessible with valid credentials.
License in practice
Apache-2.0 permissive license allows commercial and private use with minimal restrictions, suitable for most production environments.
Quickstart
pip install dbt-core dbt-clickhouse
from dbt.adapters.clickhouse import ClickhouseAdapter
# Configure via dbt profiles.yml with ClickHouse connection detailsVerify before relying
- Whether Catalog integrations (e.g., Iceberg) workarounds are production-ready or experimental
- Performance characteristics on large-scale incremental and distributed materializations
- Compatibility with dbt Cloud (documentation states not yet available)
Package facts
| License | Apache-2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 4 packagesdbt-coredbt-adaptersclickhouse-connectclickhouse-driver |
| Maintenance | Actively maintained 1 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 2,520,131 / month, #3,025 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableOperating System :: MacOS :: MacOS XOperating System :: Microsoft :: WindowsOperating System :: POSIX :: LinuxProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13 |
Evidence: dbt_clickhouse-1.10.2-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “dbt adapter for clickhouse”
- dbt-clickhouseA dbt adapter that enables data transformation and testing workflows…
- clickhouse-sqlalchemySQLAlchemy dialect for ClickHouse that enables ORM-style database…
- django-clickhouseIntegrates Django applications with ClickHouse, a columnar database,…
Give your agent the search over MCP, or paste the wish link into any chat.
More Front-Ends packages
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (ORM) that provides both a high-level ORM layer for declarative object persistence and a Core SQL construction system for direct database abstraction and query building.
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Alembic generates and manages database schema migrations for SQLAlchemy applications, handling version control of database structure changes with support for upgrades, downgrades, and auto-generation from model changes.
Install it if you use SQLAlchemy and need to version-control schema changes; skip it only if you manage migrations manually or use a different ORM entirely.
A Python client library for connecting to and querying Weaviate, a vector database that enables semantic search and AI-powered data retrieval.
A Python client library that connects to Databricks clusters and SQL warehouses using a Thrift-based protocol, conforming to the Python DB API 2.0 specification and supporting Arrow-based data exchange.
Install it if you need to query Databricks clusters or SQL warehouses from Python.
Psycopg 3 is a PostgreSQL database adapter for Python that enables applications to connect to, query, and manage PostgreSQL databases using Python code.
Install it if you need to connect Python to PostgreSQL.
See also dbt-vertica · django-clickhouse · dbt-exasol · dbt-databricks · dbt-fabric · dbt-adapters · dbt-sqlserver · dbt-athena-community · clickhouse-connect · dbt-postgres