End-to-end benchmark score
1Fresh-data path cost
ClickHouseOne service handles ingestion, ordering, merging and pre-aggregation
$28.69
BigQuery · CapacityWrite API $241.07 + MV refresh $2.02
$243.098.5×MORE
BigQuery · On-demandWrite API $241.07 + MV refresh $23.52
$264.599.2×MORE
2Query cost
ClickHouse3 Query runtime × $3.12/h
$0.051
BigQuery · Capacity79.14 slot-h × $0.06/slot-h
$4.7594×MORE
BigQuery · On-demand3.97 TiB × $6.25/TiB
$24.80491×MORE
3Query runtime
ClickHouse47.96 s for drill-down queries + 10.32 s for interactive aggregate queries
58.29 s
BigQuery · Capacity3.49 min for drill-down queries + 45.86 min for interactive aggregate queries
49.36 min51×SLOWER
BigQuery · On-demand3.49 min for drill-down queries + 45.86 min for interactive aggregate queries
49.36 min51×SLOWER
END-TO-END SCORE=(1+2)×3· LOWER IS BETTER
ClickHouse
BEST
BigQuery · Capacity
438×WORSEPERF PER $
BigQuery · On-demand
512×WORSEPERF PER $