End-to-end benchmark score

1Fresh-data path cost

ClickHouseOne service handles ingestion, ordering, merging and pre-aggregation

$28.69

DatabricksZerobus: $428.58 + clustering: $59.23 + MV refresh: $207.80

$695.6024.2×MORE

2Query cost

ClickHouse3 Query runtime × $3.12/h

$0.049

Databricks3 Query runtime × Serverless SQL WH rate: $5.46/h

$2.6554×MORE

3Query runtime

ClickHouse46.07 s for drill-down queries + 10.31 s for interactive aggregate queries

56.39 s

Databricks18.88 min for drill-down queries + 10.22 min for interactive aggregate queries

29.10 min31×SLOWER

END-TO-END SCORE=(1+2)×3· LOWER IS BETTER

ClickHouse

BEST

Databricks

752×WORSEPERF PER $