Loading…
How Suprema Gaming made its data platform agent-ready with ClickHouse Cloud
- Source
- Clickhouse
- Published
- Added to Yomu
Summary
Suprema Gaming migrated its analytics platform from Snowflake to ClickHouse Cloud on AWS as part of a company-wide move toward agentic operations. The previous stack delivered data about four hours late, required heavy dbt rebuilds, and often took minutes to answer queries, limiting real-time investigations and interactive analysis. Suprema rebuilt ingestion with ClickPipes for supported sources and Debezium plus Kafka for others, while dbt and GitHub Actions deploy the warehouse-layer structure without external cron jobs, Airflow, or a separate orchestrator; governed access uses role-based controls and query-time PII masking. Before cutover, every metric was validated against the reference source, and the resulting platform reduced warehouse spend by roughly 62%, improved direct-read performance 27x, and maintains about one-minute p95 freshness, supporting an early production deployment of ClickHouse Agents.
Context
Suprema Gaming’s Snowflake-based analytics stack was operationally sound but did not provide the speed, freshness, or cost profile needed for real-time investigations, interactive analysis, and broad access across the company. Its data was up to four hours old, queries often took minutes, and expanding usage increased warehouse costs. The company also wanted a governed foundation for AI agents to access and act on current business data.
Approach / What changed
Suprema migrated to ClickHouse Cloud on AWS and rebuilt ingestion for real-time delivery. ClickPipes handles supported sources through change data capture, while Debezium and Kafka serve other sources. dbt integrated with GitHub Actions deploys the warehouse-layer structure in one pass, without external cron jobs, Airflow, or a separate orchestrator. The architecture includes role-based access, query-time PII masking, traceability, auditing, and metric validation against the reference source before cutover.
Takeaways
- Migrated sources now arrive in ClickHouse second by second, with data moving across warehouse layers in seconds and roughly one minute of p95 lag.
- Direct reads from the marts were measured at 27x faster than the previous solution, enabling conversational BI agents to answer questions without interrupting the interaction.
- ClickHouse Cloud reduced Suprema’s warehouse spend by roughly 62%, while governance controls treat AI agents as consumers subject to access control, data minimization, masking, traceability, and auditing.