Google BigQuery

Tables: list

Requires authorization

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 Notes
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.

Authentication required

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

Signing you in...

Google Developers needs your permission to do that.