[[["Leicht verständlich","easyToUnderstand","thumb-up"],["Mein Problem wurde gelöst","solvedMyProblem","thumb-up"],["Sonstiges","otherUp","thumb-up"]],[["Schwer verständlich","hardToUnderstand","thumb-down"],["Informationen oder Beispielcode falsch","incorrectInformationOrSampleCode","thumb-down"],["Benötigte Informationen/Beispiele nicht gefunden","missingTheInformationSamplesINeed","thumb-down"],["Problem mit der Übersetzung","translationIssue","thumb-down"],["Sonstiges","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)"]]
