2020 Cloud Data Warehouse Benchmark: Redshift, Snowflake, Presto and BigQuery

Fivetran Inc. has released a benchmark comparing the performance and pricing of four popular cloud data warehouses: Amazon Redshift, Snowflake, Presto, and Google BigQuery. The study found that all warehouses had excellent execution speed suitable for ad hoc, interactive querying. However, significant differences exist in user experience and pricing models. While Redshift and BigQuery have both evolved their user experience to be more similar to Snowflake, the market is converging around two key principles: separation of compute and storage, and flat-rate pricing that can "spike" to handle intermittent workloads. The benchmark results indicate that these warehouses all offer excellent price and performance, with the most important differences being qualitative ones caused by their design choices.