Skip to content

ClickHouse (Source)

Reads from ClickHouse via the HTTP API.

Configuration

yaml
source:
  kind: clickhouse_source
  url: http://localhost:8123
  database: default
  user: default
  password: ${CLICKHOUSE_PASSWORD}
  tables:
    - events
FieldDefaultDescription
urlhttp://localhost:8123ClickHouse HTTP URL
databaseDatabase name
userdefaultUsername
passwordPassword
tables(optional)Tables to extract
queryCustom SQL query (overrides tables)

Namespace: clickhouse.{database}.{table}

CLI

bash
skippr connect source clickhouse-source \
  --url http://localhost:8123 \
  --database default \
  --user default \
  --tables events,metrics
FlagDescription
--urlHTTP interface URL
--databaseDatabase name
--userUsername
--passwordPassword
--tablesComma-separated list of tables
--querySQL query instead of table list