BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service (PaaS) that supports querying using ANSI SQL. It also has built-in machine learning capabilities. BigQuery was announced in May 2010 and made generally available in November 2011.

Design
BigQuery provides external access to Google's Dremel technology, a scalable, interactive ad hoc query system for the analysis of nested data. BigQuery requires all requests to be authenticated, supporting several Google-proprietary mechanisms such as OAuth.

Features

• Manage Data: Create and delete objects such as tables, views, and user-defined functions. Import data from Google Storage in formats such as CSV, Parquet, Avro, or JSON.
• Query: Queries are expressed in a standard SQL dialect and the results are returned in JSON with a maximum reply length of approximately 128 MB, or an unlimited size when large query results are enabled.
• Integration: BigQuery can be used from Google Apps Script (e.g., as a bound script in Google Docs), or any language that can work with its REST API or client libraries.
• Access Control: Share datasets with arbitrary individuals, groups, or the world.
• Machine Learning: Create and execute machine learning modules using SQL queries.