AtScale Cloud Data Warehouse Benchmark Report
The enterprise has entered into a new era of data warehousing. Driven by the increasing popularity of the public cloud, new data warehouse technologies are making inroads into the traditional on-premise data warehouse market. By offering customers the power of a relational, scale-out data platform without the overhead of managing it, cloud data warehouses promise to make more data available at a lower cost with fewer data management headaches.
In this inaugural cloud data warehouse benchmark analysis, we set out to quantify vendor benefits for the most popular cloud data warehouses – Google BigQuery, Amazon Redshift, and Snowflake – both with and without AtScale.
Using the standard TPC-DS (10TB) benchmarking framework, we set out to test the performance
and scalability boundaries of the various options. In addition, we also examined the operational cost dimension and we challenged the traditional data modeling techniques by testing an alternative to raw TPC-DS SQL.
The results of this study use the above metrics to quantify results in these four areas:
- Query performance: see where we found 61x faster queries on a 29 billion row data set
- Compute costs: who had 10x cheaper on a 10 TB cloud data warehouse
- Semantic complexity: where we found 76x less complexity versus raw SQL
- User concurrency: who came out on top for multiple users
Download this report today to see results in these four areas.