Why Front migrated from Elasticsearch to ClickHouse for “pixel-perfect” analytics at scale
Blog post from ClickHouse
Front migrated its customer-facing analytics from Elasticsearch to ClickHouse Cloud on AWS to manage 25 TB of data across 200 Elasticsearch nodes and reduce the engineering effort required to create metrics. The customer service platform processes tens of millions of messages daily for more than 9,000 companies, and its analytics must remain accurate even when conversations are later edited, deleted, or merged. Front moved gradually, running both systems in parallel and comparing results, then built a framework that defines each of roughly 70 metrics once and generates queries for different visualizations. ClickHouse’s SQL support and composable query design made metric development more accessible across the company, while a VersionedCollapsingMergeTree engine helps reconcile changes to underlying data. In a test involving a large customer’s tag report, a 30-second query expanded from 11 days of data in Elasticsearch to about a month and a half in ClickHouse, using roughly half as many machines of comparable performance. A metric that could take a senior engineer several weeks to build now takes a junior engineer about three days, and cloud-region transfers that previously took days can be completed in minutes. Front plans to use the platform for additional reporting capabilities, including backlog metrics and potential AI-assisted metric creation.
| Trend | Post Mentions | Total Month Mentions | Posts | Companies | MoM |
|---|---|---|---|---|---|
| Developer Experience | 1 | 231 | 155 | 47 | -52% |
Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.