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

Reference

Resources

Training and tutorials

Try BigQuery tutorials, training courses, and Qwiklabs from Google Cloud.

Qwiklabs

BigQuery for Data Warehousing

Learn best practices for extracting, transforming, and loading your data into Google Cloud with BigQuery.

Learn more  
Codelab

Preprocessing BigQuery Data with PySpark on Dataproc

Learn to create a data processing pipeline using Apache Spark with Dataproc on Google Cloud Platform. It is a common use case in data science and data engineering to read data from one storage location, perform transformations on it and write it into another storage location.

Learn more  
Qwiklabs

BigQuery For Data Analysis

Learn how to query, ingest, optimize, visualize, and even build machine learning models in SQL inside of BigQuery.

Learn more  
Qwiklabs

BigQuery for Marketing Analysts

Get repeatable, scalable, and valuable insights into your data by learning how to query it using BigQuery.

Learn more  

Use cases

Explore use cases, reference architectures, whitepapers, best practices, and industry solutions.

Use case

Migrating data warehouses to BigQuery

Learn patterns and recommendations for transitioning your on-premises data warehouse to BigQuery.

Migration Patterns BigQuery

Learn more  
Use case

Streaming data from Cloud Storage into BigQuery using Cloud Functions

Learn how to stream new objects from a Cloud Storage bucket into BigQuery by using Cloud Functions.

Learn more  
Use case

Visualizing BigQuery data in a Jupyter notebook

Use the BigQuery Python client library and Pandas in a Jupyter notebook to visualize data in a BigQuery sample table.

Learn more  
Use case

Managing healthcare data access in BigQuery

Explains strategies for securing clinical and operational healthcare data in BigQuery.

Learn more  

Code samples

Dive into coding with examples that demonstrate how to use and connect Google Cloud services.

google cloud

Client: Create credentials with scopes

Create credentials with Drive and BigQuery API scopes.

Get started  

google cloud

Client: Create credentials with application default credentials

Create a BigQuery client using application default credentials.

Get started  

google cloud

Client: Create with service account key

Create a BigQuery client using a service account key file.

Get started  

github

Python samples

Working with BigQuery with the Google Cloud Python client library

Open GitHub  

github

Node.js samples

Samples for the Node.js client library sfor BigQuery

Open GitHub  

github

C# simple sample

A simple C# program and code snippets for interacting with BigQuery

Open GitHub  

github

BigQuery and Monitoring on App Engine with Java 8

This API Showcase demonstrates how to run an App Engine standard environment application with dependencies on both BigQuery and Cloud Monitoring.

Open GitHub  

google cloud

All samples

Browse all samples for BigQuery

Get started  

Videos