BigQuery API

A data platform for customers to create, manage, share and query data.

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:

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.
getIamPolicy POST /bigquery/v2/{resource=projects/*/datasets/*/routines/*}:getIamPolicy
Gets the access control policy for a resource.
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.
setIamPolicy POST /bigquery/v2/{resource=projects/*/datasets/*/routines/*}:setIamPolicy
Sets the access control policy on the specified resource.
testIamPermissions POST /bigquery/v2/{resource=projects/*/datasets/*/routines/*}:testIamPermissions
Returns permissions that a caller has on the specified resource.
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.