Skip to main content

ClickHouse Profile

Community plugin

Some core functionality may be limited. If you're interested in contributing, check out the source code for each repository listed below.

Overview of dbt-clickhouse​

Maintained by: Community
Author: Dmitriy Sokolov
Source: https://github.com/silentsokolov/dbt-clickhouse
Core version: v0.19.0 and newer
dbt Cloud: Not Supported

dbt-clickhouse stars

The easiest way to install it is to use pip:

pip install dbt-clickhouse

Connecting to ClickHouse with dbt-clickhouse​

User / password authentication​

Configure your dbt profile for using ClickHouse:

ClickHouse connection information​
profiles.yml
dbt-clickhouse:
  target: dev
  outputs:
    dev:
      type: clickhouse
      schema: [database name]
      host: [db.clickhouse.com]
      port: 9000
      user: [user]
      password: [abc123]