Install dbt-core and dbt-clickhouse ```shell pip install dbt-clickhouse ```

Provide `dbt` with the connection details for our ClickHouse instance. The full list of connection configuration options is available here. Configure `clickhouse_cloud` profile in `~/.dbt/profiles.yml` file and provide user, password, schena host properties: ```yaml clickhouse_cloud: target: dev outputs: dev: type: clickhouse schema: host: port: 8443 # use 9440 for native user: default password: secure: True ```

Create a dbt project: ```shell dbt init project_name ```

Inside `project_name` dir, update your `dbt_project.yml` file to specify a profile name to connect to the ClickHouse server. ```yml profile: 'clickhouse_cloud' ```

Execute `dbt debug` with the CLI tool to confirm whether `dbt` is able to connect to ClickHouse.
Confirm the response includes `Connection test: [OK connection ok]` indicating a successful connection.

pg_clickhouse

Other integrations

dbt

ODBC

Calyptia

Dataddo

GrowthBook

無料で始めましょう