Datasets: list

Requires authorization

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. Try it now .

Request

HTTP request

GET https://www.googleapis.com/bigquery/v2/projects/projectId/datasets

Parameters

Parameter name	Value	Description
Path parameters
`projectId`	`string`	Project ID of the datasets to be listed
Optional query parameters
`all`	`boolean`	Whether to list all datasets, including hidden ones
`maxResults`	`unsigned integer`	The maximum number of results to return
`pageToken`	`string`	Page token, returned by a previous call, to request the next page of results

Authorization

This request requires authorization with at least one of the following scopes ( read more about authentication and authorization ).

Scope
`https://www.googleapis.com/auth/bigquery`
`https://www.googleapis.com/auth/cloud-platform`

Request body

Do not supply a request body with this method.

Response

If successful, this method returns a response body with the following structure:

{
  "kind": "bigquery#datasetList",
  "etag": etag,
  "nextPageToken": string,
  "datasets": [
    {
      "kind": "bigquery#dataset",
      "id": string,
      "datasetReference": {
        "datasetId": string,
        "projectId": string
      },
      "friendlyName": string
    }
  ]
}

Property name	Value	Description
`kind`	`bigquery#datasetList`	The list type. This property always returns the value "bigquery#datasetList".
`etag`	`etag`	A hash value of the results page. You can use this property to determine if the page has changed since the last request.
`nextPageToken`	`string`	A token that can be used to request the next results page. This property is omitted on the final results page.
`datasets[]`	`list`	An array of the dataset resources in the project. Each resource contains basic information. For full information about a particular dataset resource, use the Datasets: get method. This property is omitted when there are no datasets in the project.
`datasets[]. kind`	`string`	The resource type. This property always returns the value "bigquery#dataset".
`datasets[]. id`	`string`	The fully-qualified, unique, opaque ID of the dataset.
`datasets[]. datasetReference`	`nested object`	The dataset reference. Use this property to access specific parts of the dataset's ID, such as project ID or dataset ID.
`datasets[].datasetReference. datasetId`	`string`	[Required] A unique ID for this dataset, without the project name.
`datasets[].datasetReference. projectId`	`string`	[Optional] The ID of the container project.
`datasets[]. friendlyName`	`string`	A descriptive name for the dataset, if one exists.

Try it!

Use the APIs Explorer below to call this method on live data and see the response.

Google BigQuery