BigQuery   |  BigQuery ML   |  BigQuery BI Engine   |  BigQuery Data Transfer Service

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

Resources

• Pricing

• Release notes

• Locations

• Getting support

• Quotas and limits

• Controlling costs

• Creating custom cost controls

• Troubleshooting BigQuery quota errors

• Billing questions

• More  

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