BigQuery is a fully managed,

serverless Serverless computing is a cloud computing execution model in which the cloud provider allocates machine resources on demand, taking care of the servers on behalf of their customers. "Serverless" is a misnomer in the sense that servers are still ...

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

that enables scalable analysis over petabytes 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 category of cloud computing services that allows customers to provision, instantiate, run, and manage a modular bundle comprising a computing ...

) that supports querying using ANSI SQL. It also has built-in

machine learning Machine learning (ML) is a field of inquiry devoted to understanding and building methods that 'learn', that is, methods that leverage data to improve performance on some set of tasks. It is seen as a part of artificial intelligence. Machine ...

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

Design

BigQuery provides external access to Google's

Dremel Dremel ( ) is a multinational brand of power tools, focusing on home improvement and hobby applications. Dremel is known primarily for its rotary tools such as the Dremel 3000, 4000 and 8200 series which are similar to the pneumatic die grinder ...

technology, a scalable, interactive ''ad hoc'' query system for analysis of nested data. 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. T ...

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 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 Google Apps Script is a scripting platform developed by Google for light-weight application development in the Google Workspace platform. Google Apps Script was initially developed by Mike Harm as a side project while working as a developer on G ...

(e.g. as a bound script in

Google Docs Google Docs is an online word processor included as part of the free, web-based Google Docs Editors suite offered by Google, which also includes: Google Sheets, Google Slides, Google Drawings, Google Forms, Google Sites and Google Keep. Google Do ...

), 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. *Cross-cloud analytics - Analyze data across

Google Cloud Google Cloud Platform offers numerous integrated cloud-computing services, including compute, network, and storage. Products Past and present products under the Google Cloud platform include: Current * Google Cloud Datastore, a NoSQL databa ...

Amazon Web Services Amazon Web Services, Inc. (AWS) is a subsidiary of Amazon that provides on-demand cloud computing platforms and APIs to individuals, companies, and governments, on a metered pay-as-you-go basis. These cloud computing web services provide d ...

, and Microsoft Azure *Data sharing - Exchange data and analytics assets across organizational boundaries. *In-Memory analysis service
BI Engine
built into BigQuery that enables users to analyze large and complex datasets interactively with sub-second query response time and high concurrency. *Business intelligence - Visualize data from BigQuery by importing int
Data Studio
a data visualization tool

Pricing

The two main components of BigQuery pricing are the cost to process queries and the cost to store data. BigQuery offers two types of pricing - on demand pricing which charges for the number of petabytes processed for each query and flat-rate pricing which charges for slots or virtual CPUs.

Partnerships & integrations

BigQuery partners and natively integrates with several tools: *BI and data visualization:

Tableau Tableau (French for 'little table' literally, also used to mean 'picture'; tableaux or, rarely, tableaus) may refer to: Arts * ''Tableau'', a series of four paintings by Piet Mondrian titled '' Tableau I'' through to ''Tableau IV'' * ''Tableau vi ...

Microstrategy MicroStrategy Incorporated is an American company that provides business intelligence (BI), mobile software, and cloud-based services. Founded in 1989 by Michael J. Saylor, Sanju Bansal, and Thomas Spahr, the firm develops software to analyze ...

ThoughtSpot ThoughtSpot, Inc. is a technology company that produces business intelligence analytics search software. The company is based in Mountain View, California, and was founded in 2012. History ThoughtSpot was founded in 2012 by a team of engineers ...

, SAS and

Qlik Qlik ronounced "klik"(formerly known as Qliktech) provides a business analytics platform. The software company was founded in 1993 in Lund, Sweden and is now based in King of Prussia, Pennsylvania, United States. The company's main products ...

*Connectors and developer tools: CData, Progress, Magnitude, KingswaySoft, ZapppySys

Adoption

Customers of BigQuery include 20th Century Fox, American Eagle Outfitters, HSBC, CNA Insurance, Asahi Group, ATB Financial, Athena, The Home Depot, Wayfair, Carrefour, Oscar Health, and several others. Gartner named Google as a Leader in the 2021 Magic Quadrant™ for Cloud Database Management Systems. BigQuery is also named a Leader in The 2021 Forrester Wave: Cloud Data Warehouse. According to a study by Enterprise Strategy Group, BigQuery saves up to 27% in total cost of ownership over three years compared to other cloud data warehousing solutions.

References

External links

* {{Cloud computing Web services Google 2010 software Computer-related introductions in 2010 Big data products