This article may rely excessively on sources
too closely associated with the subject, potentially preventing the article from being
verifiable and
neutral. (May 2023) |
Type of site | Platform as a service data warehouse |
---|---|
Available in | English |
Owner | |
URL |
cloud |
Registration | Required |
Launched | May 19, 2010 |
Current status | Active |
BigQuery is a managed, serverless data warehouse product by Google, offering scalable analysis over large quantities of data. It is a Platform as a Service ( PaaS) that supports querying using a dialect of SQL. It also has built-in machine learning capabilities. BigQuery was announced in May 2010 and made generally available in November 2011. [1]
BigQuery provides external access to Google's Dremel technology, [2] [3] 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.
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. [14]
BigQuery partners and natively integrates with several tools: [15]
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. [16] Gartner named Google as a Leader in the 2021 Magic Quadrant™ for Cloud Database Management Systems. [17] BigQuery is also named a Leader in The 2021 Forrester Wave: Cloud Data Warehouse. [18] 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. [19]