Gala supercharges analytics performance with ClickHouse on AWS

ClickhouseClickHouseMay 4, 2026

Source: Clickhouse
Published: May 4, 2026
Added to Yomu: Aug 28, 2026

Problem & solution

Summary

Blockchain gaming platform Gala struggled to ingest and query expanding volumes of telemetry and blockchain data on its Databricks-based data infrastructure, resulting in multi-minute query times and heavy engineering maintenance overhead. To solve these bottlenecks, the company migrated its data platform to ClickHouse on AWS, ingesting data through Kafka, Airbyte, Amazon S3, and Fivetran. Gala leveraged ClickHouse's indexing capabilities alongside saved queries and API endpoints to power company-wide Metabase business intelligence dashboards for non-technical teams. Following the migration completed in December 2024, data capacity expanded from 3 TB to 9 TB while query times dropped from minutes to sub-second on previously unoptimized tables. The switch also lowered initial infrastructure costs by 30 percent, with plans underway to implement ClickHouse ClickPipes for improved data processing pipelines.

Context

Gala's gaming and blockchain platform generated massive amounts of telemetry and transaction data that overwhelmed its Databricks infrastructure. High query times reaching multiple minutes, escalating infrastructure management overhead, and an inability to power Metabase dashboards for non-technical business teams created operational bottlenecks as user traffic and data volumes expanded.

Approach / What changed

Gala migrated from Databricks to ClickHouse on AWS, starting with blockchain data ingestion from Kafka and expanding to Airbyte, Amazon S3, and Fivetran. The team optimized indexing, resources, and connectors, and exposed saved queries via API endpoints to integrate Metabase for self-serve analytics across non-technical teams.

Takeaways

Switching from Databricks to ClickHouse with properly configured indexing dropped query times on previously unoptimized tables from minutes to sub-second latency.
The migration allowed Gala to scale analytical data from 3 TB in February 2024 to 9 TB by December 2024 while lowering initial costs by 30 percent.
Gala enabled company-wide self-service business intelligence in Metabase by leveraging ClickHouse's ability to save queries and expose them directly via API endpoints.

Read original post

Gala supercharges analytics performance with ClickHouse on AWS

ClickhouseClickHouseMay 4, 2026

Source: Clickhouse
Published: May 4, 2026
Added to Yomu: Aug 28, 2026

Problem & solution

Summary

Context

Approach / What changed

Takeaways

Switching from Databricks to ClickHouse with properly configured indexing dropped query times on previously unoptimized tables from minutes to sub-second latency.
The migration allowed Gala to scale analytical data from 3 TB in February 2024 to 9 TB by December 2024 while lowering initial costs by 30 percent.
Gala enabled company-wide self-service business intelligence in Metabase by leveraging ClickHouse's ability to save queries and expose them directly via API endpoints.

Read original post

Related reading

Clickhouse · Mar 10, 2026
How Critical Manufacturing uses ClickHouse to bring real-time intelligence to the factory floor
Critical Manufacturing faced performance and scaling bottlenecks while processing millions of factory floor events using a legacy Microsoft SQL Server analytics stack. Increasing data volumes caused historical queries to take hours, straining real-time dashboards and escalating operational maintenance. The engineering team replaced this architecture by migrating analytics workloads to ClickHouse connected directly to streaming Kafka topics. They implemented an ELT pattern alongside ReplacingMergeTree engines to deduplicate late-arriving sensor records and utilized TTL policies for automated lifecycle management. The resulting platform delivers sub-second analytical queries across historical and real-time operational data, expands into OpenTelemetry observability storage, and maintains embeddings for retrieval-augmented generation workloads.
ClickHouse
Clickhouse · Apr 17, 2026
“A generational leap”: How Trio unified payment analytics and cut storage by 88% with ClickHouse Cloud
Brazilian payment processor Trio faced severe data challenges after scaling and acquiring PayBrokers, processing over 243 million payments in early 2025 across disparate legacy databases. Because financial reconciliation and compliance demand absolute precision, the engineering team unified their analytics layer by migrating to ClickHouse Cloud. To handle out-of-order and duplicate events from their Redpanda streaming pipelines, Trio implemented sliding-window refreshable materialized views alongside ReplacingMergeTree engines rather than recomputing entire historical datasets. A custom ETL service manages schema drift before inserting clean records into ClickHouse, while batch ingestion is coordinated through Airflow. Consequently, Trio reduced storage consumption by approximately 88% through columnar compression, ingested a 5-billion-row migration without issue, and maintained real-time query performance across more than one billion daily ledger data points.
ClickHouse
Clickhouse · Apr 14, 2026
Mintlify boosts NPS 30% and saves 60% with real-time analytics on ClickHouse Cloud
Documentation platform Mintlify experienced major dashboard performance degradation and rate limiting under PostHog as multi-tenant analytics traffic grew rapidly. Because PostHog lacked incremental materialized views, queries scanned full raw datasets and took tens of seconds to load. Mintlify migrated its customer-facing analytics infrastructure to ClickHouse Cloud, ingesting events through Amazon MSK and ClickPipes into a single events table backing incremental materialized views. The team executed the transition over two weeks by dual-writing events and replicating the existing PostHog schema to preserve API surface compatibility. The migration reduced dashboard query latency to sub-one-second, decreased related support bug reports to zero, lifted NPS by an estimated 30%, and lowered analytics infrastructure costs by approximately 60%.
ClickHouse
Clickhouse · Apr 8, 2026
The three villains to agentic observability: retention, sampling and rollups
Observability practices increasingly depend on data sampling, short retention windows, and rollups to control storage costs. While human operators historically compensated for these compromises with intuition, AI agents lack implicit operational context and require full-fidelity telemetry to diagnose issues and justify conclusions. Head sampling drops unobserved spans early, tail sampling risks missing implicit non-error anomalies, and aggressive log expiration prevents long-term cyclical trend analysis. Addressing these constraints requires decoupling storage and compute via high-compression object storage and dedicated compute pools. Deploying real-time analytical databases such as ClickHouse enables high-concurrency, low-latency SQL querying, log clustering, and structured in-database summarization necessary for automated reasoning loops.
Mike Shi