Realtime Analytics Engine

Built an ingestion and query layer for product analytics: Kafka → enrich → ClickHouse, with materialized views for the hottest dashboards and a query planner that rewrites expensive OLAP queries. Sub-second p95 on dashboards over billions of rows.

Highlights

• MV-driven pre-aggregation strategy
• Cost governor kills runaway queries
• Schemas evolved behind a contract