BigQuery
![]() |
|
---|---|
Data warehouse | |
languages | German English |
operator | Google Inc. ( more ) |
Registration | Google account required |
On-line | May 19, 2010 |
https://cloud.google.com/bigquery/ |
BigQuery is a fully managed, serverless data warehouse on the Google Cloud Platform infrastructure that enables scalable, inexpensive and fast analysis of petabytes of data. It is a software as a service (SaaS) that supports queries with ANSI SQL . It also has built-in machine learning .
history
After a limited testing period in 2010, BigQuery was generally available in November 2011 at the Google Atmosphere conference.
At the beginning of 2013, the Big Join and Big Group Aggregations functions were introduced. In April 2016, European users of the service suffered a 12 hour outage. Support for Google Sheets was announced in May 2016 .
design
BigQuery provides external access to Dremel Query Service Software, a scalable, interactive ad hoc query system for analyzing read-only nested data. BigQuery requires all requests to be authenticated, supporting a number of Google's own mechanisms as well as OAuth .
Individual evidence
- ↑ a b c Margaret Rouse: What is Google BigQuery? - Definition from WhatIs.com. In: computerweekly.com. January 15, 2017, accessed May 14, 2020 .
- ^ Iain Thomson: Google opens BigQuery for cloud analytics. In: theregister.co.uk. November 14, 2011, accessed May 14, 2020 .
- ↑ Simon Sharwood: Google Euro-cloud glitch. In: theregister.co.uk. April 7, 2016, accessed May 14, 2020 .
- ↑ Jordan Novet: Google BigQuery now lets you analyze data from Google Sheets. In: venturebeat.com. May 6, 2016, accessed May 14, 2020 .
- ↑ Sergey Melnik, Andrey Gubarev, Jing Jing Long, Geoffrey Romer, Shiva Shivakumar, Matt Tolton, Theo Vassilakis: Dremel: Interactive Analysis of Web-Scale Datasets . 2010 ( googleapis.com [PDF]).