Method: tables.list

Lists all tables in the specified dataset. Requires the READER dataset role.

HTTP request

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

The URL uses gRPC Transcoding syntax.

Path parameters

Parameters
projectId

string

Required. Project ID of the tables to list

datasetId

string

Required. Dataset ID of the tables to list

Query parameters

Parameters
maxResults

integer

The maximum number of results to return in a single response page. Leverage the page tokens to iterate through the entire collection.

pageToken

string

Page token, returned by a previous call, to request the next page of results

Request body

The request body must be empty.

Response body

Partial projection of the metadata for a given table in a list response.

If successful, the response body contains data with the following structure:

JSON representation
{
  "kind": string,
  "etag": string,
  "nextPageToken": string,
  "tables": [
    {
      "kind": string,
      "id": string,
      "tableReference": {
        object (TableReference)
      },
      "friendlyName": string,
      "type": string,
      "timePartitioning": {
        object (TimePartitioning)
      },
      "rangePartitioning": {
        object (RangePartitioning)
      },
      "clustering": {
        object (Clustering)
      },
      "hivePartitioningOptions": {
        object (HivePartitioningOptions)
      },
      "labels": {
        string: string,
        ...
      },
      "view": {
        "useLegacySql": boolean,
        "privacyPolicy": {
          object (PrivacyPolicy)
        }
      },
      "creationTime": string,
      "expirationTime": string,
      "requirePartitionFilter": boolean
    }
  ],
  "totalItems": integer
}
Fields
kind

string

The type of list.

etag

string

A hash of this page of results.

nextPageToken

string

A token to request the next page of results.

tables[]

object

Tables in the requested dataset.

tables[].kind

string

The resource type.

tables[].id

string

An opaque ID of the table.

tables[].tableReference

object (TableReference)

A reference uniquely identifying table.

tables[].friendlyName

string

The user-friendly name for this table.

tables[].type

string

The type of table.

tables[].timePartitioning

object (TimePartitioning)

The time-based partitioning for this table.

tables[].rangePartitioning

object (RangePartitioning)

The range partitioning for this table.

tables[].clustering

object (Clustering)

Clustering specification for this table, if configured.

tables[].hivePartitioningOptions

object (HivePartitioningOptions)

The hive partitioning configuration for this table, when applicable.

tables[].labels

map (key: string, value: string)

The labels associated with this table. You can use these to organize and group your tables.

An object containing a list of "key": value pairs. Example: { "name": "wrench", "mass": "1.3kg", "count": "3" }.

tables[].view

object

Additional details for a view.

tables[].view.useLegacySql

boolean

True if view is defined in legacy SQL dialect, false if in GoogleSQL.

tables[].view.privacyPolicy

object (PrivacyPolicy)

Specifices the privacy policy for the view.

tables[].creationTime

string (int64 format)

Output only. The time when this table was created, in milliseconds since the epoch.

tables[].expirationTime

string (int64 format)

The time when this table expires, in milliseconds since the epoch. If not present, the table will persist indefinitely. Expired tables will be deleted and their storage reclaimed.

tables[].requirePartitionFilter

boolean

Optional. If set to true, queries including this table must specify a partition filter. This filter is used for partition elimination.

totalItems

integer

The total number of tables in the dataset.

Authorization scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigquery
  • https://www.googleapis.com/auth/cloud-platform
  • https://www.googleapis.com/auth/bigquery.readonly
  • https://www.googleapis.com/auth/cloud-platform.read-only

For more information, see the Authentication Overview.