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. Learn 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
Guides
-
Quickstarts: Console, Command line, or Client libraries
Reference
Related resources
Data Warehouse with BigQuery Jump Start Solution
Deploy and use a sample data warehouse with BigQuery.
BigQuery for Data Warehousing
Learn best practices for extracting, transforming, and loading your data into Google Cloud with BigQuery.
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.
BigQuery For Data Analysis
Learn how to query, ingest, optimize, visualize, and even build machine learning models in SQL inside of BigQuery.
BigQuery for Marketing Analysts
Get repeatable, scalable, and valuable insights into your data by learning how to query it using BigQuery.
BigQuery for Machine Learning
Experiment with different model types in BigQuery Machine Learning, and learn what makes a good model.
Migrating data warehouses to BigQuery
Learn patterns and recommendations for transitioning your on-premises data warehouse to BigQuery.
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.
Client: Create credentials with scopes
Create credentials with Drive and BigQuery API scopes.
Client: Create credentials with application default credentials
Create a BigQuery client using application default credentials.
Client: Create with service account key
Create a BigQuery client using a service account key file.
Python samples
Working with BigQuery with the Google Cloud Python client library
Node.js samples
Samples for the Node.js client library sfor BigQuery
C# simple sample
A simple C# program and code snippets for interacting with BigQuery
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.
All samples
Browse all samples for BigQuery
Related videos
Try BigQuery for yourself
New customers also get $300 in free credits to run, test, and deploy workloads.