--- title: Why ClickHouse Cloud wins at real-time analytics | daily.dev description: ClickHouse Cloud delivered 412x to 1,996x better end-to-end performance per dollar than Snowflake, Databricks, BigQuery, and Redshift Serverless in the... canonical: https://daily.dev/posts/why-clickhouse-cloud-wins-at-real-time-analytics-qxwmahkvs twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Why ClickHouse Cloud wins at real-time analytics | daily.dev og:description: ClickHouse Cloud delivered 412x to 1,996x better end-to-end performance per dollar than Snowflake, Databricks, BigQuery, and Redshift Serverless in the... og:url: https://daily.dev/posts/why-clickhouse-cloud-wins-at-real-time-analytics-qxwmahkvs og:image: https://api.daily.dev/og/posts/QxWmAhkVS.png og:image:alt: Why ClickHouse Cloud wins at real-time analytics og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Why ClickHouse Cloud wins at real-time analytics **[ClickHouse](https://daily.dev/sources/clickhouse)** · 25 min read · 0 upvotes · 0 comments ## Summary ClickHouse Cloud delivered 412x to 1,996x better end-to-end performance per dollar than Snowflake, Databricks, BigQuery, and Redshift Serverless in the CostBench benchmark. The test streamed 113.2 billion stock-market quotes into each system while running analytical queries throughout ingestion. ClickHouse Cloud prepared all the data for $28.69, the lowest cost, and was the only system whose daily summaries stayed as fresh as its raw data. At around 100 billion rows, an aggregate query returned in about 15ms on ClickHouse versus 16 seconds on Snowflake and 4.6 seconds on BigQuery. Buildkite reportedly cut infrastructure spending by five figures per month after migrating while quadrupling ingestion. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How much faster is ClickHouse Cloud than Snowflake and BigQuery for real-time aggregate queries at scale? At roughly 100 billion raw rows, ClickHouse Cloud returned an aggregate query in about 15 milliseconds, compared with 16 seconds in Snowflake and 4.6 seconds in BigQuery. ClickHouse's pre-aggregations stayed current with raw data during ingestion, letting queries read prepared summaries directly instead of merging stale summaries with newer raw rows at query time. _Developers comparing real-time analytics databases track benchmarks like this one on daily.dev._ ### What did the CostBench benchmark find about ClickHouse Cloud's cost compared to Snowflake, Databricks, BigQuery, and Redshift Serverless? ClickHouse Cloud delivered 412 to 1,996 times better end-to-end performance per dollar than Snowflake, Databricks, BigQuery Capacity, and Redshift Serverless respectively. It ingested and prepared 113.2 billion stock-market quotes for $28.69, versus about $79 for Snowflake, $243 for BigQuery, $522 for Redshift Serverless, and $696 for Databricks. _Teams weighing data warehouse costs can follow cost-performance comparisons like this on daily.dev._ ### How does ClickHouse keep pre-aggregated summaries in sync with raw data during ingestion? ClickHouse updates pre-aggregations during inserts using incremental materialized views, sorting both raw quotes and daily summaries in memory before writing them as compressed columnar parts to disk, so raw data and summaries advance together with zero lag. Other tested systems refresh pre-aggregations asynchronously after the raw write, creating a freshness lag. _Engineers architecting ingestion pipelines can dig into mechanisms like this via daily.dev._ ## Similar posts on daily.dev - [ClickHouse Cloud vs. Snowflake: What drives the real-time performance-per-dollar gap](https://daily.dev/posts/clickhouse-cloud-vs-snowflake-what-drives-the-real-time-performance-per-dollar-gap-eic9evohu) · ClickHouse · 1 upvotes · 0 comments - [Why Databricks can’t match ClickHouse Cloud for real-time analytics](https://daily.dev/posts/why-databricks-can-t-match-clickhouse-cloud-for-real-time-analytics-ueshwi4sc) · ClickHouse · 0 upvotes · 0 comments - [Measuring real-time performance per dollar under continuous load: CostBench’s first end-to-end results](https://daily.dev/posts/measuring-real-time-performance-per-dollar-under-continuous-load-costbench-s-first-end-to-end-resul-rz7x2emyv) · ClickHouse · 1 upvotes · 0 comments - [How the 5 major cloud data warehouses compare on cost-performance](https://daily.dev/posts/how-the-5-major-cloud-data-warehouses-compare-on-cost-performance-rtkbqd6ux) · ClickHouse · 1 upvotes · 0 comments - [ClickHouse vs Snowflake: A Practical Comparison for Analytics Engineers](https://daily.dev/posts/clickhouse-vs-snowflake-a-practical-comparison-for-analytics-engineers-jdaf7whpc) · BigData Boutique blog · 1 upvotes · 0 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#snowflake](https://daily.dev/tags/snowflake), [#clickhouse](https://daily.dev/tags/clickhouse), [#real-time-analytics](https://daily.dev/tags/real-time-analytics) [View this post on daily.dev](https://daily.dev/posts/why-clickhouse-cloud-wins-at-real-time-analytics-qxwmahkvs) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Why ClickHouse Cloud wins at real-time analytics","url":"https://daily.dev/posts/why-clickhouse-cloud-wins-at-real-time-analytics-qxwmahkvs","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/why-clickhouse-cloud-wins-at-real-time-analytics-qxwmahkvs"},"datePublished":"2026-10-28T06:10:21.948Z","dateModified":"2026-10-28T06:34:20.172Z","description":"ClickHouse Cloud delivered 412x to 1,996x better end-to-end performance per dollar than Snowflake, Databricks, BigQuery, and Redshift Serverless in the...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/8440c8ee8cb8681c0c960ceb8e948114?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/8440c8ee8cb8681c0c960ceb8e948114?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"ClickHouse","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"ClickHouse","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/clickhouse","url":"https://daily.dev/sources/clickhouse"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/why-clickhouse-cloud-wins-at-real-time-analytics-qxwmahkvs","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"backend,snowflake,clickhouse,real-time-analytics","timeRequired":"PT25M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"ClickHouse","item":"https://daily.dev/sources/clickhouse"},{"@type":"ListItem","position":3,"name":"Why ClickHouse Cloud wins at real-time analytics"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/why-clickhouse-cloud-wins-at-real-time-analytics-qxwmahkvs#faq","mainEntity":[{"@type":"Question","name":"How much faster is ClickHouse Cloud than Snowflake and BigQuery for real-time aggregate queries at scale?","acceptedAnswer":{"@type":"Answer","text":"At roughly 100 billion raw rows, ClickHouse Cloud returned an aggregate query in about 15 milliseconds, compared with 16 seconds in Snowflake and 4.6 seconds in BigQuery. ClickHouse's pre-aggregations stayed current with raw data during ingestion, letting queries read prepared summaries directly instead of merging stale summaries with newer raw rows at query time. Developers comparing real-time analytics databases track benchmarks like this one on daily.dev."}},{"@type":"Question","name":"What did the CostBench benchmark find about ClickHouse Cloud's cost compared to Snowflake, Databricks, BigQuery, and Redshift Serverless?","acceptedAnswer":{"@type":"Answer","text":"ClickHouse Cloud delivered 412 to 1,996 times better end-to-end performance per dollar than Snowflake, Databricks, BigQuery Capacity, and Redshift Serverless respectively. It ingested and prepared 113.2 billion stock-market quotes for $28.69, versus about $79 for Snowflake, $243 for BigQuery, $522 for Redshift Serverless, and $696 for Databricks. Teams weighing data warehouse costs can follow cost-performance comparisons like this on daily.dev."}},{"@type":"Question","name":"How does ClickHouse keep pre-aggregated summaries in sync with raw data during ingestion?","acceptedAnswer":{"@type":"Answer","text":"ClickHouse updates pre-aggregations during inserts using incremental materialized views, sorting both raw quotes and daily summaries in memory before writing them as compressed columnar parts to disk, so raw data and summaries advance together with zero lag. Other tested systems refresh pre-aggregations asynchronously after the raw write, creating a freshness lag. Engineers architecting ingestion pipelines can dig into mechanisms like this via daily.dev."}}]} ```