BigQuery


BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a serverless Software as a Service that supports querying using ANSI SQL. It also has built-in machine learning capabilities.

History

After a limited testing period in 2010, BigQuery was generally available in November 2011 at the Google Atmosphere conference.
In April 2016, European users of the service suffered a 12-hour outage.
In May 2016, support was announced for Google Sheets.

Design

BigQuery provides external access to the Dremel technology, a scalable, interactive ad hoc query system for analysis of read-only nested data. BigQuery requires all requests to be authenticated, supporting a number of Google-proprietary mechanisms as well as OAuth.

Features