BigQuery documentation

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 GoogleSQL and taking advantage of flexible pricing models across on-demand and flat-rate options.

Go to the BigQuery product page for more.

Start your proof of concept with 300ドル in free credit

  • Get access to Gemini 2.0 Flash Thinking
  • Free monthly usage of popular products, including AI APIs and BigQuery
  • No automatic charges, no commitment

Keep exploring with 20+ always-free products

Access 20+ free products for common use cases, including AI APIs, VMs, data warehouses, and more.

Documentation resources

Find quickstarts and guides, review key references, and get help with common issues.
Explore self-paced training, use cases, reference architectures, and code samples with examples of how to use and connect Google Cloud services.
Training
Training and tutorials

Data Warehouse with BigQuery Jump Start Solution

Deploy and use a sample data warehouse with BigQuery.

Training
Training and tutorials

BigQuery for Data Warehousing

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

Training
Training and tutorials

Preprocessing BigQuery Data with PySpark on Dataproc

Learn to create a data processing pipeline using Apache Spark with Dataproc on Google Cloud. 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.

Training
Training and tutorials

BigQuery For Data Analysis

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

Training
Training and tutorials

BigQuery for Marketing Analysts

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

Training
Training and tutorials

BigQuery for Machine Learning

Experiment with different model types in BigQuery Machine Learning, and learn what makes a good model.

Use case
Use cases

Migrating data warehouses to BigQuery

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

Migration Patterns BigQuery

Use case
Use cases

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.

Code sample
Code Samples

Client: Create credentials with scopes

Create credentials with Drive and BigQuery API scopes.

Code sample
Code Samples

Client: Create credentials with application default credentials

Create a BigQuery client using application default credentials.

Code sample
Code Samples

Client: Create with service account key

Create a BigQuery client using a service account key file.

Code sample
Code Samples

Python samples

Working with BigQuery with the Google Cloud Python client library

Code sample
Code Samples

Node.js samples

Samples for the Node.js client library sfor BigQuery

Code sample
Code Samples

C# simple sample

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

Code sample
Code Samples

BigQuery and Cloud 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.

Code sample
Code Samples

All samples

Browse all samples for BigQuery

Related videos

Try BigQuery for yourself

Create an account to evaluate how our products perform in real-world scenarios.
New customers also get 300ドル in free credits to run, test, and deploy workloads.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025年11月10日 UTC.