Concepts

• BigQuery Overview

  An introduction to Google BigQuery.

• Projects

  Get started with BigQuery projects.

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

• Query Plan Explanation

  BigQuery provides diagnostic information about a completed query's execution plan.

• Authorizing API Requests

  The Google BigQuery API uses OAuth 2.0 access tokens to authorize requests. If you use the BigQuery client libraries, this is done for you automatically.

• Slots

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