BigQuery is a fully 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 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) 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 gr ...

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.

Features

* Managing data - Create and delete objects such as tables, views, and user defined functions. Import data from

Google Storage Google Cloud Storage is a RESTful online file storage web service for storing and accessing data on Google Cloud Platform infrastructure. The service combines the performance and scalability of Google's cloud with advanced security and sharing ...

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 JSON (JavaScript Object Notation, pronounced ; also ) is an open standard file format and data interchange format that uses human-readable text to store and transmit data objects consisting of attribute–value pairs and arrays (or other s ...

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 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. G ...

), 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,

Amazon Web Services Amazon Web Services, Inc. (AWS) is a subsidiary of Amazon.com, Amazon that provides Software as a service, on-demand cloud computing computing platform, platforms and Application programming interface, APIs to individuals, companies, and gover ...

, 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, Microstrategy, ThoughtSpot,

SAS SAS or Sas may refer to: Arts, entertainment, and media * ''SAS'' (novel series), a French book series by Gérard de Villiers * ''Shimmer and Shine'', an American animated children's television series * Southern All Stars, a Japanese rock ba ...

and Qlik *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