APIs and reference
BigQuery Migration Service API
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],[],[[["\u003cp\u003eThis page provides comprehensive reference documentation for interacting with BigQuery, including client libraries, API references, and command-line tools.\u003c/p\u003e\n"],["\u003cp\u003eUsers can find information on various BigQuery APIs such as the BigQuery Connection, Migration Service, Reservation, and Storage APIs, along with their respective client libraries, RPC, and REST references.\u003c/p\u003e\n"],["\u003cp\u003eThe documentation details both GoogleSQL and Legacy SQL, covering syntax, data types, functions, and specific features like arrays, wildcard tables, DML, and DDL.\u003c/p\u003e\n"],["\u003cp\u003eThere are guides for migrating from \u003ccode\u003epandas-gbq\u003c/code\u003e and \u003ccode\u003edatalab\u003c/code\u003e to the current BigQuery Python client library.\u003c/p\u003e\n"],["\u003cp\u003eThe page includes a reference for the \u003ccode\u003ebq\u003c/code\u003e command-line tool and information about BigQuery's audit logging mechanism.\u003c/p\u003e\n"]]],[],null,["# APIs and reference\n\nClient libraries\n----------------\n\n- [### BigQuery APIs and libraries overview\nAn overview of the available BigQuery APIs and client libraries.](/bigquery/docs/reference/libraries-overview) \n\nBigQuery API reference\n----------------------\n\n- [### BigQuery client libraries\n Get started with the library for the main BigQuery API.](/bigquery/docs/reference/libraries)\n- [### REST API reference\n REST API reference for version 2 of the BigQuery API.](/bigquery/docs/reference/v2)\n- [### ODBC and JDBC drivers for BigQuery\n Drivers to support ODBC and JDBC connections to BigQuery.](/bigquery/docs/reference/odbc-jdbc-drivers)\n- [### \\`pandas-gbq\\` to BigQuery Python client library migration guide\n Guide for migrating code from \\`pandas-gbq\\` to the Python client library,\n \\`google-cloud-bigquery\\`.](/bigquery/docs/pandas-gbq-migration)\n- [### Migrating from the \\`datalab\\` Python package\n Guide for migrating code from the \\`datalab\\` Python package to the\nBigQuery Python client library.](/bigquery/docs/datalab-migration) \n\nBigQuery Connection API\n-----------------------\n\n- [### BigQuery Connection API client libraries\n Library overview for the BigQuery Connection API.](/bigquery/docs/reference/bigqueryconnection)\n- [### RPC reference\n RPC reference for the BigQuery Connection API.](/bigquery/docs/reference/bigqueryconnection/rpc)\n- [### REST reference\nREST reference for the BigQuery Connection API.](/bigquery/docs/reference/bigqueryconnection/rest) \n\nBigQuery Migration Service API\n------------------------------\n\n- [### RPC reference\n RPC reference for the BigQuery Migration Service API.](/bigquery/docs/reference/migration/rpc)\n- [### REST reference\nREST reference for the BigQuery Migration Service API.](/bigquery/docs/reference/migration/rest) \n\nBigQuery Reservation API\n------------------------\n\n- [### BigQuery Reservation API client libraries\n Library information for working with the BigQuery Reservation API.](/bigquery/docs/reference/reservations)\n- [### REST reference\n REST reference for the BigQuery Reservation API.](/bigquery/docs/reference/reservations/rest)\n- [### RPC reference\nRPC reference for the BigQuery Reservation API.](/bigquery/docs/reference/reservations/rpc) \n\nBigQuery Storage API\n--------------------\n\n- [### BigQuery Storage API Overview\n Conceptual overview and information for users of the BigQuery Storage API.](/bigquery/docs/reference/storage)\n- [### BigQuery Storage API client libraries\n Library and quickstart information for users of the BigQuery Storage API.](/bigquery/docs/reference/storage/libraries)\n- [### RPC reference\nRPC reference for the BigQuery Storage API.](/bigquery/docs/reference/storage/rpc) \n\n`bq` command-line tool reference\n--------------------------------\n\n- [### \\`bq\\` command-line tool reference\nReference for the \\`bq\\` command-line tool.](/bigquery/docs/reference/bq-cli-reference) \n\nGoogleSQL reference\n-------------------\n\n- [### Switching SQL dialects\n How to enable GoogleSQL when querying data.](/bigquery/docs/introduction-sql)\n- [### GoogleSQL data types\n Data types supported by GoogleSQL.](/bigquery/docs/reference/standard-sql/data-types)\n- [### GoogleSQL query syntax\n Syntax for GoogleSQL query statements.](/bigquery/docs/reference/standard-sql/query-syntax)\n- [### GoogleSQL functions\n The complete reference for GoogleSQL expressions, including functions and\n operators.](/bigquery/docs/reference/standard-sql/functions-all)\n- [### Working with arrays in GoogleSQL\n How to use arrays in GoogleSQL.](/bigquery/docs/arrays)\n- [### GoogleSQL lexical structure\n An explanation of the tokens available in GoogleSQL statements.](/bigquery/docs/reference/standard-sql/lexical)\n- [### User-defined functions in GoogleSQL\n How to create a user-defined function in GoogleSQL.](/bigquery/docs/user-defined-functions)\n- [### Approximate aggregate functions in GoogleSQL\n How to estimate aggregate results efficiently with approximate aggregation\n in GoogleSQL.](/bigquery/docs/reference/standard-sql/approximate_aggregate_functions)\n- [### Wildcard tables in GoogleSQL\n How to query multiple tables using a wildcard in GoogleSQL.](/bigquery/docs/wildcard-table-reference)\n- [### Data Manipulation Language in GoogleSQL\n How to use the Data Manipulation Language (DML) to update, insert, and delete\n data in BigQuery.](/bigquery/docs/data-manipulation-language)\n- [### DML syntax in GoogleSQL\n Data Manipulation Language (DML) syntax reference.](/bigquery/docs/reference/standard-sql/dml-syntax)\n- [### Data Definition Language in GoogleSQL\n How to use the Data Definition Language (DDL) to modify BigQuery\n resources using GoogleSQL query syntax.](/bigquery/docs/reference/standard-sql/data-definition-language)\n- [### Procedural language in GoogleSQL\nHow to write multi-statement queries using procedural language syntax.](/bigquery/docs/reference/standard-sql/procedural-language) \n\nLegacy SQL reference\n--------------------\n\n- [### Legacy SQL functions and operators\n The complete reference for BigQuery's legacy SQL query syntax and\n functions.](/bigquery/docs/reference/legacy-sql)\n- [### Legacy SQL data types\n Data types supported by legacy SQL.](/bigquery/docs/data-types)\n- [### Querying nested and repeated fields in legacy SQL\n How to query nested and repeated fields in BigQuery using legacy SQL.](/bigquery/docs/legacy-nested-repeated)\n- [### User-defined functions in legacy SQL\n Using JavaScript user-defined functions in legacy SQL.](/bigquery/user-defined-functions)\n- [### Table decorators in legacy SQL\nHow to query a subset of your data using legacy SQL table decorators.](/bigquery/docs/table-decorators) \n\nAudit Logging reference\n-----------------------\n\n- [### Audit Logging overview\n Information about the BigQuery audit logging mechanism.](/bigquery/docs/reference/auditlogs)"]]
