Google BigQuery

API Reference

This API reference is organized by resource type. Each resource type has one or more data representations and one or more methods. 

You can see the API definition file listing all methods and resources at https://www.googleapis.com/discovery/v1/apis/bigquery/v2/rest

Resource types

  1. Datasets
  2. Jobs
  3. Projects
  4. Tabledata
  5. Tables

Datasets

For Datasets Resource details, see the resource representation page.

Method HTTP request Description
URIs relative to https://www.googleapis.com/bigquery/v2, unless otherwise noted
delete DELETE  /projects/projectId/datasets/datasetId Deletes the dataset specified by the datasetId value. Before you can delete a dataset, you must delete all its tables, either manually or by specifying deleteContents. Immediately after deletion, you can create another dataset with the same name.
get GET  /projects/projectId/datasets/datasetId Returns the dataset specified by datasetID.
insert POST  /projects/projectId/datasets Creates a new empty dataset.
list GET  /projects/projectId/datasets Lists all the datasets in the specified project to which the caller has read access; however, a project owner can list (but not necessarily get) all datasets in his project.
patch PATCH  /projects/projectId/datasets/datasetId Updates information in an existing dataset. The update method replaces the entire dataset resource, whereas the patch method only replaces fields that are provided in the submitted dataset resource. This method supports patch semantics.
update PUT  /projects/projectId/datasets/datasetId Updates information in an existing dataset. The update method replaces the entire dataset resource, whereas the patch method only replaces fields that are provided in the submitted dataset resource.

Jobs

For Jobs Resource details, see the resource representation page.

Method HTTP request Description
URIs relative to https://www.googleapis.com/bigquery/v2, unless otherwise noted
get GET  /projects/projectId/jobs/jobId Retrieves the specified job by ID.
getQueryResults GET  /projects/projectId/queries/jobId Retrieves the results of a query job.
insert POST
https://www.googleapis.com/upload/bigquery/v2/projects/projectId/jobs

and
POST  /projects/projectId/jobs
Starts a new asynchronous job.
list GET  /projects/projectId/jobs Lists all the Jobs in the specified project that were started by the user.
query POST  /projects/projectId/queries Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout.

Projects

For Projects Resource details, see the resource representation page.

Method HTTP request Description
URIs relative to https://www.googleapis.com/bigquery/v2, unless otherwise noted
list GET  /projects Lists the projects to which you have at least read access.

Tabledata

For Tabledata Resource details, see the resource representation page.

Method HTTP request Description
URIs relative to https://www.googleapis.com/bigquery/v2, unless otherwise noted
insertAll POST  /projects/projectId/datasets/datasetId/tables/tableId/insertAll Inserts the supplied rows into the table.
list GET  /projects/projectId/datasets/datasetId/tables/tableId/data Retrieves table data from a specified set of rows.

Tables

For Tables Resource details, see the resource representation page.

Method HTTP request Description
URIs relative to https://www.googleapis.com/bigquery/v2, unless otherwise noted
delete DELETE  /projects/projectId/datasets/datasetId/tables/tableId Deletes the table specified by tableId from the dataset. If the table contains data, all the data will be deleted.
get GET  /projects/projectId/datasets/datasetId/tables/tableId Gets the specified table resource by table ID. This method does not return the data in the table, it only returns the table resource, which describes the structure of this table.
insert POST  /projects/projectId/datasets/datasetId/tables Creates a new, empty table in the dataset.
list GET  /projects/projectId/datasets/datasetId/tables Lists all tables in the specified dataset.
patch PATCH  /projects/projectId/datasets/datasetId/tables/tableId Updates information in an existing table. The update method replaces the entire table resource, whereas the patch method only replaces fields that are provided in the submitted table resource. This method supports patch semantics.
update PUT  /projects/projectId/datasets/datasetId/tables/tableId Updates information in an existing table. The update method replaces the entire table resource, whereas the patch method only replaces fields that are provided in the submitted table resource.

Authentication required

You need to be signed in with Google+ to do that.

Signing you in...

Google Developers needs your permission to do that.