AtScale Cloud Data Warehouse Benchmark: Google BigQuery

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 Google BigQuery, 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 show how AtScale works with Google BigQuery to:

  • Run 7.7x faster queries on a 29 billion row data set
  • Reduce cost by 10x on a 10 TB cloud data warehouse
  • Bring query complexity down by 75% versus raw SQL
  • Improve user concurrency by up to 20x

Download this report today to see Google BigQuery’s results in these four areas.

Get your free copy