# BigQuery documentation  |  Google Cloud Documentation
# Source: https://docs.cloud.google.com/bigquery/docs
# Path: /bigquery/docs

  * [ Home ](https://docs.cloud.google.com/)
  * [ Documentation ](https://docs.cloud.google.com/docs)
  * [ Data analytics ](https://docs.cloud.google.com/docs/data)
  * [ BigQuery ](https://docs.cloud.google.com/bigquery/docs)



# BigQuery documentation

[Read product documentation](https://docs.cloud.google.com/bigquery/docs/introduction)

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.](https://cloud.google.com/bigquery)

[Get started for free](https://console.cloud.google.com/freetrial)

#### Start your proof of concept with $300 in free credit

  * Develop with our latest Generative AI models and tools. 
  * Get free usage of 20+ popular products, including Compute Engine and AI APIs. 
  * No automatic charges, no commitment. 



[ View free product offers ](/free/docs/free-cloud-features#free-tier)

#### 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. 

format_list_numbered 

### Guides

  * Quickstarts: [Console](/bigquery/docs/quickstarts/query-public-dataset-console), [Command line](/bigquery/docs/quickstarts/load-data-bq), or [Client libraries](/bigquery/docs/quickstarts/quickstart-client-libraries)

  * [ Creating and using tables ](/bigquery/docs/tables)

  * [ Introduction to partitioned tables ](/bigquery/docs/partitioned-tables)

  * [ Introduction to BigQuery AI ](/bigquery/docs/ai-introduction)

  * [ Predefined roles and permissions ](/bigquery/docs/access-control)

  * [ Introduction to loading data ](/bigquery/docs/loading-data)

  * [ Loading CSV data from Cloud Storage ](/bigquery/docs/loading-data-cloud-storage-csv)

  * [ Exporting table data ](/bigquery/docs/exporting-data)

  * [ Create machine learning models in BigQuery ML ](/bigquery/docs/create-machine-learning-model)

  * [ Querying external data sources ](/bigquery/external-data-sources)

  * [ Introduction to vector search ](/bigquery/docs/vector-search-intro)




find_in_page 

### Reference

  * [ Functions in GoogleSQL ](/bigquery/docs/reference/standard-sql/functions-all)

  * [ Operators in GoogleSQL ](/bigquery/docs/reference/standard-sql/operators)

  * [ Conditional expressions in GoogleSQL ](/bigquery/docs/reference/standard-sql/conditional_expressions)

  * [ Date functions in GoogleSQL ](/bigquery/docs/reference/standard-sql/date_functions)

  * [ Query syntax in GoogleSQL ](/bigquery/docs/reference/standard-sql/query-syntax)

  * [ String functions in GoogleSQL ](/bigquery/docs/reference/standard-sql/string_functions)

  * [ Using the bq command-line tool ](/bigquery/docs/bq-command-line-tool)

  * [ End-to-end journey for machine learning models ](/bigquery/docs/reference/standard-sql/bigqueryml-syntax-e2e-journey)

  * [ BigQuery API Client Libraries ](/bigquery/docs/reference/libraries)

  * [ Creating and training models ](/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create)

  * [ Public datasets ](/bigquery/public-data)

  * [ Feature preprocessing ](/bigquery/docs/reference/standard-sql/bigqueryml-syntax-preprocess-overview)




info 

### Resources

  * [ Pricing ](https://cloud.google.com/bigquery/pricing)

  * [ Release notes ](/bigquery/docs/release-notes)

  * [ Locations ](/bigquery/docs/locations)

  * [ Getting support ](/bigquery/docs/getting-support)

  * [ Quotas and limits ](/bigquery/quotas)

  * [ Controlling costs ](/bigquery/docs/controlling-costs)

  * [ Creating custom cost controls ](/bigquery/docs/custom-quotas)

  * [ Troubleshooting BigQuery quota errors ](/bigquery/docs/troubleshoot-quotas)

  * [ Billing questions ](/bigquery/docs/billing-questions)




##  Related resources 

Training and tutorials

Use cases

Code samples

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 ](https://cloud.google.com/architecture/big-data-analytics/data-warehouse)

Deploy and use a sample data warehouse with BigQuery. 

Training 

Training and tutorials

###  [ BigQuery for Data Warehousing ](https://www.cloudskillsboost.google/course_templates/679)

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 ](https://codelabs.developers.google.com/codelabs/pyspark-bigquery/)

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 ](https://www.cloudskillsboost.google/course_templates/865)

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 ](https://www.cloudskillsboost.google/course_templates/678)

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 ](https://www.cloudskillsboost.google/course_templates/680)

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 ](/solutions/migration/dw2bq/dw-bq-migration-overview)

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 ](/bigquery/docs/visualize-jupyter)

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 ](/bigquery/docs/samples/bigquery-auth-drive-scope)

Create credentials with Drive and BigQuery API scopes. 

Code sample 

Code Samples

###  [ Client: Create credentials with application default credentials ](/bigquery/docs/samples/bigquery-client-default-credentials)

Create a BigQuery client using application default credentials. 

Code sample 

Code Samples

###  [ Client: Create with service account key ](/bigquery/docs/samples/bigquery-client-json-credentials)

Create a BigQuery client using a service account key file. 

Code sample 

Code Samples

###  [ Python samples ](https://github.com/googleapis/python-bigquery/tree/main/samples)

Working with BigQuery with the Google Cloud Python client library 

Code sample 

Code Samples

###  [ Node.js samples ](https://github.com/googleapis/nodejs-bigquery/tree/main/samples)

Samples for the Node.js client library sfor BigQuery 

Code sample 

Code Samples

###  [ C# simple sample ](https://github.com/GoogleCloudPlatform/dotnet-docs-samples/tree/master/bigquery/api)

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 ](https://github.com/GoogleCloudPlatform/java-docs-samples/tree/main/appengine-java8/bigquery)

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 ](/bigquery/docs/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. 

[ Try BigQuery free ](https://console.cloud.google.com/freetrial)

Except as otherwise noted, the content of this page is licensed under the [Creative Commons Attribution 4.0 License](https://creativecommons.org/licenses/by/4.0/), and code samples are licensed under the [Apache 2.0 License](https://www.apache.org/licenses/LICENSE-2.0). For details, see the [Google Developers Site Policies](https://developers.google.com/site-policies). Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-17 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-12-17 UTC."],[],[]]