Logo DWBI.org Login / Sign Up
Sign Up
Have Login?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Login
New Account?
Recovery
Go to Login
GCP Analytics

Google BigQuery

Updated on Oct 13, 2021

BigQuery is Google's fully-managed, petabyte scale, low-cost enterprise data warehouse to manage and analyze large amount of data with built-in features like machine learning, geospatial analysis, and business intelligence.

BigQuery is serverless. BigQuery's scalable, distributed analysis engine lets you query terabytes in seconds and petabytes in minutes. BigQuery combines a cloud-based data warehouse and powerful analytic tools. It is a petabyte-scale analytics data warehouse that you can use to run SQL queries over vast amounts of data in near real-time.

BigQuery maximizes flexibility by separating the compute engine that analyzes your data from your storage choices like Google Cloud Storage, Bigtable, Spanner. You can store and analyze your data within BigQuery or use BigQuery to assess your data where it lives using external tables or federated queries.

BigQuery stores data using a columnar storage format that is optimized for analytical queries. BigQuery presents data in tables, rows, and columns and provides full support for database transaction semantics (ACID). BigQuery storage is automatically replicated across multiple locations to provide high availability.

BigQuery charges for querying/processing data. Those queries are charged to the credit card of the billing project.