BigQuery is Google Cloud's fully managed, petabyte-scale, and cost-effective analytics data warehouse that lets you run analytics over vast amounts of data in near real time. With BigQuery, there's no infrastructure to set up or manage, letting you focus on finding meaningful insights using standard SQL and taking advantage of flexible pricing models across on-demand and flat-rate options. Learn more
Guides
-
Quickstarts: Console, Command line, or Client libraries
-
Creating and using tables
-
Introduction to partitioned tables
-
Using the BigQuery sandbox
-
Predefined roles and permissions
-
Loading CSV data from Cloud Storage
-
Exporting table data
-
Introduction to loading data
-
Streaming data into BigQuery
-
Querying external data sources
Reference
-
Expressions, functions, and operators in Standard SQL
-
Date functions in Standard SQL
-
Query syntax in Standard SQL
-
String functions in Standard SQL
-
Using the bq command-line tool
-
BigQuery API Client Libraries
-
BigQuery APIs and Libraries Overview
-
BigQuery storage API overview
-
Overview of audit logging
-
Public datasets
Training and tutorials
Try BigQuery tutorials, training courses, and Qwiklabs from Google Cloud.
Use cases
Explore use cases, reference architectures, whitepapers, best practices, and industry solutions.
Code samples
Dive into coding with examples that demonstrate how to use and connect Google Cloud services.