Concepts

General Concepts

• BigQuery Overview

  An introduction to Google BigQuery.

• Projects

  Learn about BigQuery projects.

• Jobs

  An introduction to BigQuery jobs.

• Interacting with BigQuery

  Tools and methods of interacting with BigQuery.

• Datasets, Tables, Views, and Labels

  Use datasets, tables, and views to organize, store, and query data.

• Storing Data

  Store data in BigQuery.

• Data Formats

  Formats supported by BigQuery for loading and exporting data.

• Schema Auto-Detection

  BigQuery offers schema auto-detection when you load data and when you query external data.

• Access Control

  BigQuery uses access control lists (ACLs) to manage permissions on projects and datasets.

• Partitioned Tables

  BigQuery offers date-partitioned tables, which enable you to reduce bytes processed and improve query performance by limiting the amount of data scanned during a query.

• Slots

  BigQuery slots are units of computational capacity required to execute SQL queries.

Best Practices

• Controlling Costs

  Best practices for controlling costs in BigQuery.

• Optimizing Query Performance

  Best practices for optimizing query performance in BigQuery.

• Optimizing Storage

  Best practices for optimizing BigQuery storage.