dbt-clickhouse
This plugin ports dbt functionality to Clickhouse.
Documentation
See the ClickHouse website for the full documentation entry.
The documentation source is maintained in docs.
Installation
Use your favorite Python package manager to install the app from PyPI, e.g.
pip install dbt-core dbt-clickhouse
NOTE: Beginning in v1.8, dbt-core and adapters are decoupled. Therefore, the installation mentioned above explicitly includes both dbt-core and the desired adapter.If you use a version prior to 1.8.0 the pip installation command should look like this:
pip install dbt-clickhouse
Supported features
- Table materialization
- View materialization
- Incremental materialization
- Microbatch incremental materialization
- Materialized View materializations (uses the
TOform of MATERIALIZED VIEW, experimental) - Seeds
- Sources
- Docs generate
- Tests
- Snapshots
- Most dbt-utils macros (now included in dbt-core)
- Ephemeral materialization
- Distributed table materialization (experimental)
- Distributed incremental materialization (experimental)
- Contracts
- ClickHouse-specific column configurations (Codec, TTL...)
- ClickHouse-specific table settings (indexes, projections...)
All features up to dbt-core 1.10 are supported, including --sample flag and all deprecation warnings fixed for future releases. Catalog integrations (e.g., Iceberg) introduced in dbt 1.10 are not yet natively supported in the adapter, but workarounds are available. See the Catalog Support section for details.
This adapter is still not available for use inside dbt Cloud, but we expect to make it available soon. Please reach out to support to get more information on this.
Contributing
We welcome contributions from the community to help improve the dbt-ClickHouse adapter. Whether you’re fixing a bug, adding a new feature, or enhancing documentation, your efforts are greatly appreciated!
Please take a moment to read our Contribution Guide to get started. The guide provides detailed instructions on setting up your environment, running tests, and submitting pull requests.
Original Author
ClickHouse wants to thank @silentsokolov for creating this connector and for their valuable contributions.
4 maintainers
Release files for dbt-clickhouse 1.10.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| dbt_clickhouse-1.10.3.tar.gz | 58.8 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| dbt_clickhouse-1.10.3-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 132.8 kB
Release files / dbt_clickhouse-1.10.3.tar.gz
| Download URL | dbt_clickhouse-1.10.3.tar.gz |
|---|---|
| Size | 58.8 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
cf1dd5787ab83c97548dcbbc7bb580434eab9de52f538aa78d3bf6a54342915d
|
|
BLAKE2b-256 checksum How to use checksums |
97a4045bdaadf59066510c780351b592ad04ec5ca0e067128e2b535317857c01
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 15, 2026.
Transparency logRelease files / dbt_clickhouse-1.10.3-py3-none-any.whl
| Download URL | dbt_clickhouse-1.10.3-py3-none-any.whl |
|---|---|
| Size | 74.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
2f377515ae0dc3e36b524ca6c0f70dd5993a1d87ca8152dec543bb6efd88b1cf
|
|
BLAKE2b-256 checksum How to use checksums |
b39e5c362e9b4b9cceda077ac9914c85f411a798a03dce81cec090fb6fd56597
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 15, 2026.
Transparency log
