ClickHouse Integration

ClickHouse is an alternative analytics store for CDEvents, suited to very large event volumes or organizations already standardized on ClickHouse. The collector writes events through the ClickHouse sink.

NOTE

The pre-built Grafana dashboards currently require the PostgreSQL event store. With ClickHouse you bring your own dashboards and queries.

Setup

Enable the ClickHouse sink in the collector configuration:

[sinks.clickhouse]
enabled = true
type = "clickhouse"

Connection URL, table layout, and all options are covered in the ClickHouse Sink reference.

When to Choose ClickHouse

• Very high event throughput or long retention where columnar storage pays off
• Existing ClickHouse-based analytics platform to join delivery events with other data
• Otherwise, prefer PostgreSQL — it powers the full CDviz experience out of the box