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]