clickhouse dbt logo

dbt-clickhouse

This plugin ports dbt functionality to Clickhouse.

Documentation

See the ClickHouse website for the full documentation entry.

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 TO form 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.

Project links

Data verified by PyPI on Aug 13, 2026
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Latest release

4 maintainers

PyPI data
Data sourced directly from PyPI's database.
Avatar for bleviav from gravatar.com bleviav Avatar for genzgd from gravatar.com genzgd Avatar for joe-clickhouse from gravatar.com joe-clickhouse
+1 more Avatar for mshustov from gravatar.com mshustov

Credits

Author: ClickHouse Inc.

GitHub Statistics

Data verified by PyPI on Aug 13, 2026
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

License expression

Apache-2.0
View SPDX License List

Requires

Python >=3.10

Classifiers

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbt_clickhouse-1.10.2.tar.gz (58.1 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

dbt_clickhouse-1.10.2-py3-none-any.whl (73.3 kB view details)

Uploaded Python 3

File details

Details for the file dbt_clickhouse-1.10.2.tar.gz.

File metadata

  • Download URL: dbt_clickhouse-1.10.2.tar.gz
  • Upload date:
  • Size: 58.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for dbt_clickhouse-1.10.2.tar.gz
Algorithm Hash digest
SHA256 1a2b04a44d74ce6ed84ee125dcc79217f070643e0f81eb3a649e88e04e72599f
MD5 a0f253a28ba9d888fe7243256ae20cd2
BLAKE2b-256 05775adc9a10173a5f9aac24126c28591a35414c1ea00197102394219cbc3a6b

See more details on using hashes here.

Provenance

The following attestation bundles were made for dbt_clickhouse-1.10.2.tar.gz:

Publisher: pypi.yml on ClickHouse/dbt-clickhouse

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file dbt_clickhouse-1.10.2-py3-none-any.whl.

File metadata

  • Download URL: dbt_clickhouse-1.10.2-py3-none-any.whl
  • Upload date:
  • Size: 73.3 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for dbt_clickhouse-1.10.2-py3-none-any.whl
Algorithm Hash digest
SHA256 0cc03dcc25ac25467d0aab29c740ed96771082172bbfee8478bdbc550567cf8a
MD5 b9ad3ac63d18a910425386b41b13226b
BLAKE2b-256 e476a65ac160bba50c428f735f16b8c38a1c3f04eeed32bc676c5960eea3fffb

See more details on using hashes here.

Provenance

The following attestation bundles were made for dbt_clickhouse-1.10.2-py3-none-any.whl:

Publisher: pypi.yml on ClickHouse/dbt-clickhouse

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Release history Release notifications | RSS feed

This release

1.10.2 This release

2 files

1.10.1

2 files

1.10.0

2 files

1.9.8

2 files

1.9.7

2 files

1.9.6

2 files

1.9.5

2 files

1.9.4

2 files

1.9.3

2 files

1.9.2

2 files

1.9.1

2 files

1.9.0

2 files

1.8.9

2 files

1.8.8

2 files

1.8.7

2 files

1.8.6

2 files

1.8.5

2 files

1.8.4

2 files

1.8.3

2 files

1.8.2

2 files

1.8.1

2 files

1.8.0

2 files

1.7.7

2 files

1.7.6

2 files

1.7.5

2 files

1.7.4

2 files

1.7.3

2 files

1.7.2

2 files

1.7.1

2 files

1.7.0

2 files

1.6.2

2 files

1.6.1

2 files

1.6.0

2 files

1.5.2

2 files

1.5.1

2 files

1.5.0

2 files

1.4.9

2 files

1.4.8

2 files

1.4.7

2 files

1.4.6

2 files

1.4.5

2 files

1.4.4

2 files

1.4.2

2 files

1.4.1

2 files

1.4.0

2 files

1.3.3

2 files

1.3.2

2 files

1.3.1

2 files

1.3.0

2 files

1.2.2

2 files

1.2.1

2 files

1.1.8

2 files

1.1.7

2 files

1.1.6

2 files

1.1.5

2 files

1.1.3

2 files

1.1.2

2 files

1.1.0.2

2 files

1.1.0.1

2 files

1.1.0

2 files

1.0.4

2 files

1.0.1

2 files

1.0.0

2 files

0.21.1

2 files

0.21.0

2 files

0.20.2

2 files

0.20.1

2 files

0.20.0

2 files

0.19.1.1

2 files

0.19.1

2 files

0.19.0.3

2 files

0.19.0.2

2 files

0.19.0.1

2 files

0.19.0

2 files

0.18.2.1

2 files

0.18.2

2 files

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page