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

Fivetran has conducted 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 speeds suitable for ad hoc, interactive querying. However, each warehouse has unique user experiences and pricing models, with some being more fully managed than others. Fivetran's benchmark results differ from previous studies due to various factors such as data scale, configuration settings, and the complexity of queries used. The most important differences between warehouses are their design choices, emphasizing tunability or ease of use.