From Surf Wiki (app.surf) — the open knowledge base

BigQuery

Cloud-based data warehouse service

Field	Value
name	BigQuery
logo_size	128px
type	Platform as a service data warehouse
language	English
current_status	Active
url
registration	Required
owner	Google
launch_date

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.

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.

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

Iain Thomson. (November 14, 2011). "Google opens BigQuery for cloud analytics: Dangles free trial to lure doubters".
(2010). "Dremel: Interactive Analysis of Web-Scale Datasets". Proc. of the 36th International Conference on Very Large Data Bases (VLDB).
Kazunori Sato. (2012). "An Inside Look at Google BigQuery".
Kwek, Ju-Kay. "BigQuery: the unlikely birth of a cloud juggernaut".
(26 May 2010). "Google I/O 2010 - BigQuery and Prediction APIs".
"SQL Reference".
"Quota Policy".
(March 15, 2018). "BigQuery Service".
"BigQuery Client Libraries".

Info: Wikipedia Source

This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page.

web-services google 2010-software internet-properties-established-in-2010 big-data-products cloud_databases

Want to explore this topic further?

Ask Mako anything about BigQuery — get instant answers, deeper analysis, and related topics.

Research with Mako

Free with your Surf account

Content sourced from Wikipedia, available under CC BY-SA 4.0.

This content may have been generated or modified by AI. CloudSurf Software LLC is not responsible for the accuracy, completeness, or reliability of AI-generated content. Always verify important information from primary sources.

Report