TPC-H for less than a cent: ClickHouse Cloud vs. Snowflake, Databricks, BigQuery, and Redshift

In a comprehensive benchmark comparison using the TPC-H SF100 workload, ClickHouse Cloud demonstrated competitive performance against major cloud data warehouses like Snowflake, Databricks, BigQuery, and Redshift, achieving the best cost-performance ratio. The tests, which involved executing 22 join-heavy analytical queries over 866 million rows, showed that ClickHouse Cloud's single 59-core node was not only efficient in raw runtime but also exceptionally cost-effective, completing the workload in 19.8 seconds for $0.063. The study highlighted the difficulty of direct performance comparisons due to varied compute configurations among cloud providers but underscored ClickHouse Cloud's advantage in delivering high join performance per dollar. Furthermore, scaling down to SF10, ClickHouse Cloud executed the full workload for less than one cent, showcasing its unrivaled cost-performance efficiency. These results stem from two years of focused engineering improvements aimed at enhancing join operations, making ClickHouse 26 times faster than previous iterations. Looking ahead, ClickHouse intends to scale its capabilities for larger datasets with multi-stage distributed query execution, building on its optimized join performance.