BigQuery API | Google Cloud (2024)

Home
BigQuery
Documentation
Reference

Service: bigquery.googleapis.com

To call this service, we recommend that you use the Google-provided client libraries. If your application needs to use your own libraries to call this service, use the following information when you make the API requests.

Discovery document

A Discovery Document is a machine-readable specification for describing and consuming REST APIs. It is used to build client libraries, IDE plugins, and other tools that interact with Google APIs. One service may provide multiple discovery documents. This service provides the following discovery document:

https://bigquery.googleapis.com/discovery/v1/apis/bigquery/v2/rest

Service endpoint

A service endpoint is a base URL that specifies the network address of an API service. One service might have multiple service endpoints. This service has the following service endpoint and all URIs below are relative to this service endpoint:

https://bigquery.googleapis.com

REST Resource: v2.datasets

Methods
`delete`	`DELETE /bigquery/v2/projects/{projectId}/datasets/{datasetId}` Deletes the dataset specified by the datasetId value.
`get`	`GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}` Returns the dataset specified by datasetID.
`insert`	`POST /bigquery/v2/projects/{projectId}/datasets` Creates a new empty dataset.
`list`	`GET /bigquery/v2/projects/{projectId}/datasets` Lists all datasets in the specified project to which the user has been granted the READER dataset role.
`patch`	`PATCH /bigquery/v2/projects/{projectId}/datasets/{datasetId}` Updates information in an existing dataset.
`undelete`	`POST /bigquery/v2/projects/{projectId}/datasets/{datasetId}:undelete` Undeletes a dataset which is within time travel window based on datasetId.
`update`	`PUT /bigquery/v2/projects/{projectId}/datasets/{datasetId}` Updates information in an existing dataset.

REST Resource: v2.jobs

Methods
`cancel`	`POST /bigquery/v2/projects/{projectId}/jobs/{jobId}/cancel` Requests that a job be cancelled.
`delete`	`DELETE /bigquery/v2/projects/{projectId}/jobs/{jobId}/delete` Requests the deletion of the metadata of a job.
`get`	`GET /bigquery/v2/projects/{projectId}/jobs/{jobId}` Returns information about a specific job.
`getQueryResults`	`GET /bigquery/v2/projects/{projectId}/queries/{jobId}` RPC to get the results of a query job.
`insert`	`POST /bigquery/v2/projects/{projectId}/jobs` `POST /upload/bigquery/v2/projects/{projectId}/jobs` Starts a new asynchronous job.
`list`	`GET /bigquery/v2/projects/{projectId}/jobs` Lists all jobs that you started in the specified project.
`query`	`POST /bigquery/v2/projects/{projectId}/queries` Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout.

REST Resource: v2.models

Methods
`delete`	`DELETE /bigquery/v2/projects/{projectId}/datasets/{datasetId}/models/{modelId}` Deletes the model specified by modelId from the dataset.
`get`	`GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/models/{modelId}` Gets the specified model resource by model ID.
`list`	`GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/models` Lists all models in the specified dataset.
`patch`	`PATCH /bigquery/v2/projects/{projectId}/datasets/{datasetId}/models/{modelId}` Patch specific fields in the specified model.

REST Resource: v2.projects

Methods
`getServiceAccount`	`GET /bigquery/v2/projects/{projectId}/serviceAccount` RPC to get the service account for a project used for interactions with Google Cloud KMS
`list`	`GET /bigquery/v2/projects` RPC to list projects to which the user has been granted any project role.

REST Resource: v2.routines

Methods
`delete`	`DELETE /bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines/{routineId}` Deletes the routine specified by routineId from the dataset.
`get`	`GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines/{routineId}` Gets the specified routine resource by routine ID.
`insert`	`POST /bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines` Creates a new routine in the dataset.
`list`	`GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines` Lists all routines in the specified dataset.
`update`	`PUT /bigquery/v2/projects/{projectId}/datasets/{datasetId}/routines/{routineId}` Updates information in an existing routine.

REST Resource: v2.rowAccessPolicies

Methods
`getIamPolicy`	`POST /bigquery/v2/{resource=projects//datasets//tables//rowAccessPolicies/}:getIamPolicy` Gets the access control policy for a resource.
`list`	`GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/rowAccessPolicies` Lists all row access policies on the specified table.
`testIamPermissions`	`POST /bigquery/v2/{resource=projects//datasets//tables//rowAccessPolicies/}:testIamPermissions` Returns permissions that a caller has on the specified resource.

REST Resource: v2.tabledata

Methods
`insertAll`	`POST /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll` Streams data into BigQuery one record at a time without needing to run a load job.
`list`	`GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/data` List the content of a table in rows.

REST Resource: v2.tables

Methods
`delete`	`DELETE /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}` Deletes the table specified by tableId from the dataset.
`get`	`GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}` Gets the specified table resource by table ID.
`getIamPolicy`	`POST /bigquery/v2/{resource=projects//datasets//tables/*}:getIamPolicy` Gets the access control policy for a resource.
`insert`	`POST /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables` Creates a new, empty table in the dataset.
`list`	`GET /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables` Lists all tables in the specified dataset.
`patch`	`PATCH /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}` Updates information in an existing table.
`setIamPolicy`	`POST /bigquery/v2/{resource=projects//datasets//tables/*}:setIamPolicy` Sets the access control policy on the specified resource.
`testIamPermissions`	`POST /bigquery/v2/{resource=projects//datasets//tables/*}:testIamPermissions` Returns permissions that a caller has on the specified resource.
`update`	`PUT /bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}` Updates information in an existing table.

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.

Last updated 2024-04-01 UTC.