# 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 or Python 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) ## Documentation resources Find quickstarts and guides, review key references, and get help with common issues. ### Guides - Quickstarts: [Console](https://docs.cloud.google.com/bigquery/docs/quickstarts/query-public-dataset-console), [Command line](https://docs.cloud.google.com/bigquery/docs/quickstarts/load-data-bq), [Client libraries](https://docs.cloud.google.com/bigquery/docs/quickstarts/quickstart-client-libraries), or [BigQuery DataFrames (Python)](https://docs.cloud.google.com/bigquery/docs/dataframes-quickstart) - [Creating and using tables](https://docs.cloud.google.com/bigquery/docs/tables) - [Introduction to partitioned tables](https://docs.cloud.google.com/bigquery/docs/partitioned-tables) - [Introduction to BigQuery AI](https://docs.cloud.google.com/bigquery/docs/ai-introduction) - [Predefined roles and permissions](https://docs.cloud.google.com/bigquery/docs/access-control) - [Introduction to loading data](https://docs.cloud.google.com/bigquery/docs/loading-data) - [Loading CSV data from Cloud Storage](https://docs.cloud.google.com/bigquery/docs/loading-data-cloud-storage-csv) - [Exporting table data](https://docs.cloud.google.com/bigquery/docs/exporting-data) - [Create machine learning models in BigQuery ML](https://docs.cloud.google.com/bigquery/docs/create-machine-learning-model) - [Querying external data sources](https://docs.cloud.google.com/bigquery/external-data-sources) - [Introduction to vector search](https://docs.cloud.google.com/bigquery/docs/vector-search-intro) - [What is the BigQuery Data Transfer Service?](https://docs.cloud.google.com/bigquery/docs/dts-introduction) - [Introduction to BigQuery migration](https://docs.cloud.google.com/bigquery/docs/migration-intro) ### Reference - [Functions in GoogleSQL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/functions-all) - [Operators in GoogleSQL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/operators) - [Conditional expressions in GoogleSQL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/conditional_expressions) - [Date functions in GoogleSQL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/date_functions) - [Query syntax in GoogleSQL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax) - [String functions in GoogleSQL](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/string_functions) - [Using the bq command-line tool](https://docs.cloud.google.com/bigquery/docs/bq-command-line-tool) - [End-to-end journey for machine learning models](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-e2e-journey) - [BigQuery DataFrames (Python)](https://dataframes.bigquery.dev/reference/index.html) - [BigQuery API Client Libraries](https://docs.cloud.google.com/bigquery/docs/reference/libraries) - [Creating and training models](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create) - [Public datasets](https://docs.cloud.google.com/bigquery/public-data) - [Feature preprocessing](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-preprocess-overview) ### Resources - [Pricing](https://cloud.google.com/bigquery/pricing) - [Release notes](https://docs.cloud.google.com/bigquery/docs/release-notes) - [Locations](https://docs.cloud.google.com/bigquery/docs/locations) - [Getting support](https://docs.cloud.google.com/bigquery/docs/getting-support) - [Quotas and limits](https://docs.cloud.google.com/bigquery/quotas) - [Controlling costs](https://docs.cloud.google.com/bigquery/docs/controlling-costs) - [Creating custom cost controls](https://docs.cloud.google.com/bigquery/docs/custom-quotas) - [Troubleshooting BigQuery quota errors](https://docs.cloud.google.com/bigquery/docs/troubleshoot-quotas) - [Billing questions](https://docs.cloud.google.com/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 ### [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. Codelab Training and tutorials ### [Preprocessing BigQuery Data with PySpark on Managed Service for Apache Spark](https://codelabs.developers.google.com/codelabs/pyspark-bigquery/) Learn to create a data processing pipeline using Apache Spark with Managed Service for Apache Spark 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](https://docs.cloud.google.com/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](https://docs.cloud.google.com/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](https://docs.cloud.google.com/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](https://docs.cloud.google.com/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](https://docs.cloud.google.com/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/GoogleCloudPlatform/python-docs-samples/tree/main/bigquery) Working with BigQuery with the BigQuery DataFrames and Google Cloud Python client library Code sample Code Samples ### [Node.js samples](https://github.com/GoogleCloudPlatform/nodejs-docs-samples/tree/main/bigquery/cloud-client) Samples for the Node.js client library for 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](https://docs.cloud.google.com/bigquery/docs/samples) Browse all samples for BigQuery ## Related videos