dbt ClickHouse setup in minutes
Use dbt ClickHouse with the Matatika platform in minutes.
Automate dbt ClickHouse from a single space with no code
ClickHouse is a high-performance, column-oriented SQL database for online analytical processing (OLAP).
dbt (data build tool) is an open-source command-line tool that lets data analysts and engineers transform data in their warehouse using SQL. The dbt-clickhouse adapter (community-maintained by ClickHouse Inc.) lets dbt models, tests, snapshots and seeds run directly against ClickHouse, so ClickHouse workspaces get the same transformation workflow available for Postgres, Snowflake and BigQuery.
Settings
Skip Pre-invoke
A boolean value indicating whether to skip pre-invoke checks.
dbt Profile type
The type of dbt profile being used (e.g. clickhouse).
Projects Directory
The directory where dbt projects are stored.
Profiles Directory
The directory where dbt profiles are stored.
Host
The hostname or IP address of the ClickHouse server.
User
The username used to connect to the ClickHouse server.
Password
The password used to connect to the ClickHouse server.
Port
The port used to connect to the ClickHouse server (8123 for HTTP, 8443 for HTTPS).
Schema
The ClickHouse database (schema) to use.
Secure (TLS)
Connect over HTTPS/TLS (set for ClickHouse Cloud).
View source code
dbt ClickHouse with your data warehouse
Use dbt ClickHouse with your data warehouse or ours.
