Overview Quickstart CLI Commands .sql Models .py Models profiles.yml sources.yml Execution Paths

CLICKHOUSE

Column-oriented OLAP database for real-time analytics. Designed for sub-second queries over billions of rows.

PREREQUISITES

Driver: clickhouse-connect — installed automatically by:

dvt sync

CONFIGURATION FIELDS

FIELD	TYPE	REQUIRED	DEFAULT	DESCRIPTION
type	string	yes	—	Must be `clickhouse`
host	string	yes	localhost	ClickHouse server hostname
port	integer	no	9000	Native protocol port
user	string	no	default	Database username
password	string	no	—	Database password
database	string	no	default	Database name
threads	integer	no	4	Number of parallel threads

PROFILES.YML EXAMPLE

my_project:
  target: ch_dev
  outputs:
    ch_dev:
      type: clickhouse
      host: localhost
      port: 9000
      user: default
      password: "{{ env_var('CH_PASSWORD') }}"
      database: analytics

SOURCES.YML EXAMPLE

sources:
  - name: clickhouse_data
    connection: ch_dev
    database: analytics
    tables:
      - name: events
      - name: metrics

INCREMENTAL STRATEGIES

✓ Append✓ Delete+Insert✓ Merge