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

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]