End-to-end benchmark score

1Fresh-data path cost

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

$28.69

SnowflakeSnowpipe Streaming: $53.15 + materialized-view refresh: $26.27

$79.422.8×MORE

2Query cost

ClickHouse3 Query runtime × $3.12/h

$0.054

Snowflake3 Interactive WH portion × $3.60/h + 3 Fallback WH portion × $8.10/h

$15.99298×MORE

3Query runtime

ClickHouse50.47 s for drill-down queries + 11.36 s for interactive aggregate queries

1.03 min

Snowflake1.25 min for drill-down queries + 2.11 h for interactive aggregate queries

2.13 h124×SLOWER

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

ClickHouse

BEST

Snowflake

412×WORSEPERF PER $