Tables: list

Lists all tables in the specified dataset. Try it now .

Required ACLs: To call this method, you must have one of the following rights:

Dataset READ
Dataset WRITE
Dataset OWNER

Request

HTTP request

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

Parameters

Parameter name	Value	Description
Path parameters
`datasetId`	`string`	Dataset ID of the tables to list
`projectId`	`string`	Project ID of the tables to list
Optional query parameters
`maxResults`	`unsigned integer`	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#tableList",
  "etag": etag,
  "nextPageToken": string,
  "tables": [
    {
      "kind": "bigquery#table",
      "id": string,
      "tableReference": {
        "projectId": string,
        "datasetId": string,
        "tableId": string
      },
      "friendlyName": string,
      "type": string
    }
  ],
  "totalItems": integer
}

Property name	Value	Description
`kind`	`bigquery#tableList`	The type of list.
`etag`	`etag`	A hash of this page of results.
`nextPageToken`	`string`	A token to request the next page of results.
`tables[]`	`list`	Tables in the requested dataset.
`tables[]. kind`	`string`	The resource type.
`tables[]. id`	`string`	An opaque ID of the table
`tables[]. tableReference`	`nested object`	A reference uniquely identifying the table.
`tables[].tableReference. projectId`	`string`	[Required] The ID of the project that contains the table.
`tables[].tableReference. datasetId`	`string`	[Required] The ID of the dataset that contains the table.
`tables[].tableReference. tableId`	`string`	[Required] The table ID.
`tables[]. friendlyName`	`string`	The user-friendly name for this table.
`totalItems`	`integer`	The total number of tables in the dataset.
`tables[]. type`	`string`	The type of table. Possible values are: TABLE, VIEW.

Try it!

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

Google BigQuery