Leveraging ClickHouse to build a caching layer within Sigma

How Sigma uses ClickHouse as a caching layer to cut latency and compute costs for high-concurrency workloads.

Sigma's analytics platform pushes SQL directly to cloud data warehouses, but at scale, latency and compute costs demand a smarter approach. This session covers Sigma's multi-tier query architecture, why ClickHouse became the right caching layer for high-concurrency workloads, and how Sigma routes queries intelligently between the primary warehouse and ClickHouse, with concrete patterns you can apply to your own stack.

This is an Open House 2026 session. https://clickhouse.com/openhouse/san-francisco