BigQuery is a managed, serverless

data warehouse In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for Business intelligence, reporting and data analysis and is a core component of business intelligence. Data warehouses are central Re ...

product by

Google Google LLC (, ) is an American multinational corporation and technology company focusing on online advertising, search engine technology, cloud computing, computer software, quantum computing, e-commerce, consumer electronics, and artificial ...

, offering scalable analysis over large quantities of data. It is a ''Platform as a Service'' (

PaaS Platform as a service (PaaS) or application platform as a service (aPaaS) or platform-based service is a cloud computing service model where users provision, instantiate, run and manage a modular bundle of a computing platform and applications, w ...

) that supports querying using a dialect of

SQL Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...

. It also has built-in

machine learning Machine learning (ML) is a field of study in artificial intelligence concerned with the development and study of Computational statistics, statistical algorithms that can learn from data and generalise to unseen data, and thus perform Task ( ...

capabilities. BigQuery was announced in May 2010 and made generally available in November 2011.

History

Bigquery originated from Google's internal Dremel technology, which enabled quick queries across trillions of rows of data. The product was originally announced in May 2010 at Google I/O. Initially, it was only usable by a limited number of external early adopters due to limitations on the API. However, after the product proved its potential, it was released for limited availability in 2011 and general availability in 2012. After general availability, BigQuery found success among a broad range of customers, including airlines, insurance, and retail organizations.

Design

BigQuery requires all requests to be authenticated, supporting a number of Google-proprietary mechanisms as well as

OAuth OAuth (short for open authorization) is an open standard for access delegation, commonly used as a way for internet users to grant websites or applications access to their information on other websites but without giving them the passwords. Th ...

Features

* Managing 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 SQL dialect and the results are returned in

JSON JSON (JavaScript Object Notation, pronounced or ) is an open standard file format and electronic data interchange, data interchange format that uses Human-readable medium and data, human-readable text to store and transmit data objects consi ...

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 models using SQL queries.

References

External links

* {{Cloud computing Web services Google 2010 software Internet properties established in 2010 Big data products Cloud_databases