--- title: 1セント未満で実現するTPC-H:ClickHouse Cloud vs.... description: ClickHouse Cloud ran the full TPC-H benchmark against Snowflake, Databricks, BigQuery, and Redshift. On SF100 (100GB, 866M rows, 22 JOIN-heavy queries), a... canonical: https://daily.dev/posts/1-tpc-h-clickhouse-cloud-vs-snowflake-databricks-bigquery-redshift-cyr7sio3u twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: 1セント未満で実現するTPC-H:ClickHouse Cloud vs. Snowflake、Databricks、BigQuery、Redshift | daily.dev og:description: ClickHouse Cloud ran the full TPC-H benchmark against Snowflake, Databricks, BigQuery, and Redshift. On SF100 (100GB, 866M rows, 22 JOIN-heavy queries), a... og:url: https://daily.dev/posts/1-tpc-h-clickhouse-cloud-vs-snowflake-databricks-bigquery-redshift-cyr7sio3u og:image: https://api.daily.dev/og/posts/cYr7SIo3u.png og:image:alt: 1セント未満で実現するTPC-H:ClickHouse Cloud vs. Snowflake、Databricks、BigQuery、Redshift 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. # 1セント未満で実現するTPC-H:ClickHouse Cloud vs. Snowflake、Databricks、BigQuery、Redshift **[ClickHouse](https://daily.dev/sources/clickhouse)** · 2 min read · 0 upvotes · 0 comments ## Summary ClickHouse Cloud ran the full TPC-H benchmark against Snowflake, Databricks, BigQuery, and Redshift. On SF100 (100GB, 866M rows, 22 JOIN-heavy queries), a single 59-core ClickHouse Cloud node completed the workload in 19.8 seconds at $0.063 — achieving the best cost-performance score, roughly 2x better than the nearest competitor (Snowflake Large). On SF10, all 22 queries finished in 2.9 seconds for under $0.009. These results stem from two years of focused JOIN engineering, including better query planning, correlated subquery support, lazy column materialization, runtime filters, and statistics-based JOIN order optimization — delivering a 26x speedup on the same workload compared to two years ago. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [TPC-H for less than a cent: ClickHouse Cloud vs. Snowflake, Databricks, BigQuery, and Redshift](https://daily.dev/posts/tpc-h-for-less-than-a-cent-clickhouse-cloud-vs-snowflake-databricks-bigquery-and-redshift-7g58szban) · ClickHouse · 0 upvotes · 0 comments - [主要5大クラウドデータウェアハウスのコストパフォーマンス比較](https://daily.dev/posts/5--earsnhsrw) · ClickHouse · 0 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 - [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 - [Agentic analytics starts with query-ready data: the write-side cost of Snowflake vs. ClickHouse](https://daily.dev/posts/agentic-analytics-starts-with-query-ready-data-the-write-side-cost-of-snowflake-vs-clickhouse-3ycxolfnb) · ClickHouse · 0 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#snowflake](https://daily.dev/tags/snowflake), [#clickhouse](https://daily.dev/tags/clickhouse), [#data-warehouse](https://daily.dev/tags/data-warehouse) [View this post on daily.dev](https://daily.dev/posts/1-tpc-h-clickhouse-cloud-vs-snowflake-databricks-bigquery-redshift-cyr7sio3u) ```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":"1セント未満で実現するTPC-H:ClickHouse Cloud vs. Snowflake、Databricks、BigQuery、Redshift","url":"https://daily.dev/posts/1-tpc-h-clickhouse-cloud-vs-snowflake-databricks-bigquery-redshift-cyr7sio3u","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/1-tpc-h-clickhouse-cloud-vs-snowflake-databricks-bigquery-redshift-cyr7sio3u"},"datePublished":"2026-06-05T11:54:25.952Z","dateModified":"2026-06-05T12:00:26.264Z","description":"ClickHouse Cloud ran the full TPC-H benchmark against Snowflake, Databricks, BigQuery, and Redshift. On SF100 (100GB, 866M rows, 22 JOIN-heavy queries), a...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/6f22082175dac1a30c0323af5f6010f2?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/6f22082175dac1a30c0323af5f6010f2?_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/1-tpc-h-clickhouse-cloud-vs-snowflake-databricks-bigquery-redshift-cyr7sio3u","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,snowflake,clickhouse,data-warehouse","timeRequired":"PT2M"} {"@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":"1セント未満で実現するTPC-H:ClickHouse Cloud vs. Snowflake、Databricks、BigQuery、Redshift"}]} ```