Fivetran’s Cloud Data Warehouse Benchmark compared Redshift, Snowflake, BigQuery, Databricks, and Synapse on cost and performance using a 1TB TPC-DS dataset and 99 complex queries. All warehouses delivered strong interactive query speed, with Databricks showing the biggest gains after rewriting its SQL engine. Costs varied by configuration, with Snowflake, BigQuery, and Databricks generally competitive, while Redshift results were less consistent due to cache sensitivity. The study concludes no single warehouse is dramatically faster; all rely on established optimizations like columnar storage and query planning. The real differences lie in usability, tunability, and platform design.

Join for free to read