Array ( [0] => {{Short description|Cloud-based data warehouse service}} [1] => {{Third-party|date=May 2023}} [2] => {{Infobox website [3] => | name = BigQuery [4] => | logo = [5] => | logo_size = 128px [6] => | type = [[Platform as a service]] [[data warehouse]] [7] => | language = [[English language|English]] [8] => | current_status = Active [9] => | url = {{URL|https://cloud.google.com/bigquery}} [10] => | registration = Required [11] => | owner = [[Google]] [12] => | launch_date = {{start date and age|2010|5|19}} [13] => }} [14] => [15] => '''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'' ([[Cloud computing#Platform as a service (PaaS)|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.{{Cite web |title= Google opens BigQuery for cloud analytics: Dangles free trial to lure doubters |author= Iain Thomson |website= [[The Register]] |date= November 14, 2011 |url= https://www.theregister.co.uk/2011/11/14/google_bigquery_cloud_analytics/ |access-date = August 26, 2016 }} [16] => [17] => == Design == [18] => BigQuery provides external access to Google's [[Dremel (software)|Dremel]] technology,{{cite web [19] => |url=http://research.google.com/pubs/pub36632.html [20] => |author1=Sergey Melnik |author2=Andrey Gubarev |author3=Jing Jing Long |author4=Geoffrey Romer |author5=Shiva Shivakumar |author6=Matt Tolton |author7=Theo Vassilakis |work=Proc. of the 36th International Conference on Very Large Data Bases (VLDB) [21] => |year = 2010 [22] => |title=Dremel: Interactive Analysis of Web-Scale Datasets}}{{Cite web |title= An Inside Look at Google BigQuery |author= Kazunori Sato |year= 2012 |url= https://cloud.google.com/files/BigQueryTechnicalWP.pdf |access-date = August 26, 2016 }} 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]]. [23] => [24] => == Features == [25] => * 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. [26] => * Query - Queries are expressed in a SQL dialect{{cite web|title=SQL Reference|url=https://cloud.google.com/bigquery/docs/reference/standard-sql/|access-date=26 June 2017}} 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.{{cite web|title=Quota Policy|url=https://cloud.google.com/bigquery/quota-policy#queries|access-date=26 June 2017}} [27] => * Integration - BigQuery can be used from [[Google Apps Script]]{{Cite web |title= BigQuery Service | Apps Script | Google Developers |date= March 15, 2018 |url= https://developers.google.com/apps-script/advanced/bigquery |access-date = April 23, 2018 }} (e.g. as a bound script in [[Google Docs]]), or any language that can work with its REST API or client libraries.{{cite web|title=BigQuery Client Libraries|url=https://cloud.google.com/bigquery/docs/reference/libraries|access-date=26 June 2017}} [28] => * Access control - Share datasets with arbitrary individuals, groups, or the world. [29] => * Machine learning - Create and execute machine learning models using SQL queries. [30] => *Cross-cloud analytics - Analyze data across [[Google Cloud]], [[Amazon Web Services]], and [[Microsoft Azure]]{{cite web |url=https://cloud.google.com/bigquery/docs/omni-introduction:https://cloud.google.com/bigquery/docs/omni-introduction |title=bigquery }}{{Dead link|date=October 2023 |bot=InternetArchiveBot |fix-attempted=yes }}{{cite web|url= https://techcrunch.com/2021/10/12/google-clouds-bigquery-omni-is-now-generally-available/|title=Google Clouds BiqQuery Omni Now Generally Available|date=12 October 2021 }} [31] => *Data sharing - Exchange data and analytics assets across organizational boundaries.{{cite web|url=https://cloud.google.com/analytics-hub|title=Analytics Hub}} [32] => *In-Memory analysis service - [https://cloud.google.com/bigquery/docs/bi-engine-intro BI Engine] built into BigQuery that enables users to analyze large and complex datasets interactively with sub-second query response time and high concurrency.{{cite web|url=https://cloud.google.com/bigquery/docs/bi-engine-intro|title=BI Engine}}{{cite web|url=https://medium.com/codex/google-with-many-updates-in-bigquery-and-data-studio-18dbdd36b290|title= With Many Updates in BigQuery|date= 2 July 2022}} [33] => *Business intelligence - Visualize data from BigQuery by importing into [https://datastudio.google.com/ Data Studio], a data visualization tool {{cite web|url=https://medium.com/codex/google-with-many-updates-in-bigquery-and-data-studio-18dbdd36b290|title= with Many Updates in BigQuery|date= 2 July 2022}} [34] => [35] => == Pricing == [36] => 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.{{cite web|url=https://blog.coupler.io/bigquery-cost/ |title=BigQuery Costs|date=13 July 2023 }} [37] => [38] => == Partnerships & integrations == [39] => BigQuery partners and natively integrates with several tools:{{cite web|url=https://cloud.google.com/bigquery#section-12 |title=BigQuery Section}} [40] => *BI and data visualization: [[Tableau Software|Tableau]], [[Microstrategy]], [[ThoughtSpot]], [[SAS (software)|SAS]], [[Qlik]] Neo4j and [[Dataiku]] [41] => *Connectors and developer tools: CData, Progress, Magnitude, KingswaySoft, ZapppySys [42] => [43] => == Adoption == [44] => 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.{{cite web|url=https://cloud.google.com/customers#/products=Data_Analytics|title=Customers for Data Analytics}} Gartner named Google as a Leader in the 2021 Magic Quadrant™ for Cloud Database Management Systems.{{cite web|url=https://solutionsreview.com/data-management/whats-changed-2021-gartner-magic-quadrant-for-cloud-database-management-systems/|title=Whats Changed 2021 Gartner Magic Quadrant for Cloud Database Management Systems|date=13 January 2022 }} BigQuery is also named a Leader in The 2021 Forrester Wave: Cloud Data Warehouse.{{cite web|url=https://www.pointstar.com.my/blog/bigquery-named-leader-in-forrester-wave-cloud-data-warehouse-q1-2021/|title=BigQuery named leader in forrester wave cloud data warehouse|date=30 March 2021 }} [45] => 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.{{cite web|url=https://services.google.com/fh/files/misc/esg_economic_validation_google_bigquery_vs_cloud_based_edws_jun_2022.pdf |title=Economic Validation Google BigQuery va. Cloud Based EDWS}} [46] => [47] => == References == [48] => {{Reflist}} [49] => [50] => == External links == [51] => *{{Official website|https://cloud.google.com/bigquery/what-is-bigquery}} [52] => [53] => {{Google LLC}} [54] => {{Google Cloud}} [55] => {{Cloud computing}} [56] => [57] => [[Category:Web services]] [58] => [[Category:Google]] [59] => [[Category:2010 software]] [60] => [[Category:Internet properties established in 2010]] [61] => [[Category:Big data products]] [] => )
good wiki

BigQuery

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.

More about us

About

Expert Team

Vivamus eget neque lacus. Pellentesque egauris ex.

Award winning agency

Lorem ipsum, dolor sit amet consectetur elitorceat .

10 Year Exp.

Pellen tesque eget, mauris lorem iupsum neque lacus.

You might be interested in

Google

Google is an American multinational technology company specializing in Internet-related services and products.

SQL

SQL (Structured Query Language) is a standard programming language for managing and manipulating relational databases.