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-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]