APIs and reference

Client libraries

• BigQuery APIs and libraries overview

  An overview of the available BigQuery APIs and client libraries.

BigQuery API reference

• BigQuery client libraries

  Get started with the library for the main BigQuery API.

• REST API reference

  REST API reference for version 2 of the BigQuery API.

• `pandas-gbq` to BigQuery Python client library migration guide

  Guide for migrating code from `pandas-gbq` to the Python client library, `google-cloud-bigquery`.

• Migrating from the `datalab` Python package

  Guide for migrating code from the `datalab` Python package to the BigQuery Python client library.

BigQuery Connection API

• BigQuery Connection API client libraries

  Library overview for the BigQuery Connection API.

• RPC reference

  RPC reference for the BigQuery Connection API.

• REST reference

  REST reference for the BigQuery Connection API.

BigQuery Reservation API

• BigQuery Reservation API client libraries

  Library information for working with the BigQuery Reservation API.

• REST reference

  REST reference for the BigQuery Reservation API.

• RPC reference

  RPC reference for the BigQuery Reservation API.

BigQuery Storage API

• BigQuery Storage API Overview

  Conceptual overview and information for users of the BigQuery Storage API.

• BigQuery Storage API client libraries

  Library and quickstart information for users of the BigQuery Storage API.

• RPC reference

  RPC reference for the BigQuery Storage API.

bq command-line tool reference

• `bq` command-line tool reference

  Reference for the `bq` command-line tool.

Standard SQL reference

• Switching SQL dialects

  How to enable standard SQL when querying data.

• Standard SQL data types

  Data types supported by standard SQL.

• Standard SQL query syntax

  Syntax for standard SQL query statements.

• Standard SQL functions and operators

  The complete reference for standard SQL expressions, including functions and operators.

• Working with arrays in standard SQL

  How to use arrays in standard SQL.

• Standard SQL lexical structure

  An explanation of the tokens available in standard SQL statements.

• User-defined functions in standard SQL

  How to create a user-defined function in standard SQL.

• Approximate aggregate functions in standard SQL

  How to estimate aggregate results efficiently with approximate aggregation in standard SQL.

• Wildcard tables in standard SQL

  How to query multiple tables using a wildcard in standard SQL.

• Data Manipulation Language in standard SQL

  How to use the Data Manipulation Language (DML) to update, insert, and delete data in BigQuery.

• DML syntax in standard SQL

  Data Manipulation Language (DML) syntax reference.

• Data Definition Language in standard SQL

  How to use the Data Definition Language (DDL) to modify BigQuery resources using standard SQL query syntax.

• Scripting in standard SQL

  How to write scripts using standard SQL query syntax.

Legacy SQL reference

• Legacy SQL functions and operators

  The complete reference for BigQuery's legacy SQL query syntax and functions.

• Legacy SQL data types

  Data types supported by legacy SQL.

• Querying nested and repeated fields in legacy SQL

  How to query nested and repeated fields in BigQuery using legacy SQL.

• User-defined functions in legacy SQL

  Using JavaScript user-defined functions in legacy SQL.

• Table decorators in legacy SQL

  How to query a subset of your data using legacy SQL table decorators.

Audit Logging reference

• Audit Logging overview

  Information about the BigQuery audit logging mechanism.