ClickHouse (Destination)

Loads data into ClickHouse over HTTP.

Configuration

warehouse:
  kind: clickhouse
  url: http://localhost:8123
  database: default
  user: default
  password: ${CLICKHOUSE_PASSWORD}

Field	Default	Description
url	http://localhost:8123	ClickHouse HTTP URL
database		Database name
user	default	Username
password		Password

CLI

skippr connect warehouse clickhouse \
  --url http://localhost:8123 \
  --database default \
  --user default \
  --password "$CLICKHOUSE_PASSWORD"

Flag	Description
--url	HTTP interface URL (default: http://localhost:8123)
--database	Database name (default: default)
--user	Username (default: default)
--password	Password

CDC

ClickHouse supports CDC with ReplacingMergeTree engine semantics. Skippr automatically creates _skippr_order_token columns and tombstone tables.

See CDC Destinations -- ClickHouse for details.