Tables: list

Requires authorization

Lists all tables in the specified dataset. Requires the READER dataset role. Try it now.

Access control: For more information, see access control.


HTTP request



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


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


Request body

Do not supply a request body with this method.


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,
      "timePartitioning": {
        "type": string,
        "expirationMs": long
      "labels": {
        (key): string
      "view": {
        "useLegacySql": boolean
  "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 containing this table.
tables[].tableReference.datasetId string [Required] The ID of the dataset containing this table.
tables[].tableReference.tableId string [Required] The ID of the table. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
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.
tables[].view object Additional details for a view.
tables[].view.useLegacySql boolean True if view is defined in legacy SQL dialect, false if in standard SQL.
tables[].labels object [Experimental] The labels associated with this table. You can use these to organize and group your tables.
tables[].labels.(key) string
tables[].timePartitioning nested object [Experimental] The time-based partitioning for this table.
tables[].timePartitioning.type string [Required] The only type supported is DAY, which will generate one partition per day based on data loading time.
tables[].timePartitioning.expirationMs long [Optional] Number of milliseconds for which to keep the storage for a partition.

Try it!

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

Send feedback about...