--- title: "GET /projects/{projectsId}/datasets/{datasetsId}/tables" method: GET path: "/projects/{projectsId}/datasets/{datasetsId}/tables" tags: ["tables"] --- # GET /projects/{projectsId}/datasets/{datasetsId}/tables `GET /projects/{projectsId}/datasets/{datasetsId}/tables` ## Request - Base URL: `https://bigquery.googleapis.com/bigquery/v2` - URL: `https://bigquery.googleapis.com/bigquery/v2/projects/{projectsId}/datasets/{datasetsId}/tables` - Auth: one of: - OAuth 2 and OAuth 2 - Implicit: `https://accounts.google.com/o/oauth2/auth` - Scopes: `https://www.googleapis.com/auth/bigquery` - Authorization code: `https://accounts.google.com/o/oauth2/auth` - Token URL: `https://accounts.google.com/o/oauth2/token` scopes: `https://www.googleapis.com/auth/bigquery` - OAuth 2 and OAuth 2 - Implicit: `https://accounts.google.com/o/oauth2/auth` - Scopes: `https://www.googleapis.com/auth/cloud-platform` - Authorization code: `https://accounts.google.com/o/oauth2/auth` - Token URL: `https://accounts.google.com/o/oauth2/token` scopes: `https://www.googleapis.com/auth/cloud-platform` - OAuth 2 and OAuth 2 - Implicit: `https://accounts.google.com/o/oauth2/auth` - Scopes: `https://www.googleapis.com/auth/cloud-platform.read-only` - Authorization code: `https://accounts.google.com/o/oauth2/auth` - Token URL: `https://accounts.google.com/o/oauth2/token` scopes: `https://www.googleapis.com/auth/cloud-platform.read-only` Lists all tables in the specified dataset. Requires the READER dataset role. # IAM Permissions Requires the `bigquery.tables.list` permission on the dataset. ## Path parameters - `projectsId` string, required - `datasetsId` string, required ## Query parameters - `maxResults` integer - `pageToken` string ## Response `200` Successful response - TableList: Partial projection of the metadata for a given table in a list response. - `etag` string: A hash of this page of results. - `kind` string: The type of list. - `nextPageToken` string: A token to request the next page of results. - `tables` object[]: Tables in the requested dataset. - `clustering` Clustering: Configures table clustering. - `fields` string[]: One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. The ordering of the clustering fields should be prioritized from most to least important for filtering purposes. For additional information, see [Introduction to clustered tables](https://cloud.google.com/bigquery/docs/clustered-tables#limitations). - `creationTime` string, int64: Output only. The time when this table was created, in milliseconds since the epoch. - `expirationTime` string, int64: 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. - `friendlyName` string: The user-friendly name for this table. - `id` string: An opaque ID of the table. - `kind` string: The resource type. - `labels` object: The labels associated with this table. You can use these to organize and group your tables. - `rangePartitioning` RangePartitioning - `field` string: Required. The name of the column to partition the table on. It must be a top-level, INT64 column whose mode is NULLABLE or REQUIRED. - `range` object: [Experimental] Defines the ranges for range partitioning. - `end` string, int64: [Experimental] The end of range partitioning, exclusive. - `interval` string, int64: [Experimental] The width of each interval. - `start` string, int64: [Experimental] The start of range partitioning, inclusive. - `requirePartitionFilter` boolean: Optional. If set to true, queries including this table must specify a partition filter. This filter is used for partition elimination. - `tableReference` TableReference - `datasetId` string: Required. The ID of the dataset containing this table. - `projectId` string: Required. The ID of the project containing this table. - `tableId` string: Required. The ID of the table. The ID can contain Unicode characters in category L (letter), M (mark), N (number), Pc (connector, including underscore), Pd (dash), and Zs (space). For more information, see [General Category](https://wikipedia.org/wiki/Unicode_character_property#General_Category). The maximum length is 1,024 characters. Certain operations allow suffixing of the table ID with a partition decorator, such as `sample_table$20190123`. - `timePartitioning` TimePartitioning - `expirationMs` string, int64: Optional. Number of milliseconds for which to keep the storage for a partition. A wrapper is used here because 0 is an invalid value. - `field` string: Optional. If not set, the table is partitioned by pseudo column '_PARTITIONTIME'; if set, the table is partitioned by this field. The field must be a top-level TIMESTAMP or DATE field. Its mode must be NULLABLE or REQUIRED. A wrapper is used here because an empty string is an invalid value. - `requirePartitionFilter` boolean: If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. This field is deprecated; please set the field with the same name on the table itself instead. This field needs a wrapper because we want to output the default value, false, if the user explicitly set it. - `type` string: Required. The supported types are DAY, HOUR, MONTH, and YEAR, which will generate one partition per day, hour, month, and year, respectively. - `type` string: The type of table. - `view` object: Information about a logical view. - `privacyPolicy` PrivacyPolicy: Represents privacy policy that contains the privacy requirements specified by the data owner. Currently, this is only supported on views. - `aggregationThresholdPolicy` AggregationThresholdPolicy: Represents privacy policy associated with "aggregation threshold" method. - `privacyUnitColumns` string[]: Optional. The privacy unit column(s) associated with this policy. For now, only one column per data source object (table, view) is allowed as a privacy unit column. Representing as a repeated field in metadata for extensibility to multiple columns in future. Duplicates and Repeated struct fields are not allowed. For nested fields, use dot notation ("outer.inner") - `threshold` string, int64: Optional. The threshold for the "aggregation threshold" policy. - `differentialPrivacyPolicy` DifferentialPrivacyPolicy: Represents privacy policy associated with "differential privacy" method. - `deltaBudget` number, double: Optional. The total delta budget for all queries against the privacy-protected view. Each subscriber query against this view charges the amount of delta that is pre-defined by the contributor through the privacy policy delta_per_query field. If there is sufficient budget, then the subscriber query attempts to complete. It might still fail due to other reasons, in which case the charge is refunded. If there is insufficient budget the query is rejected. There might be multiple charge attempts if a single query references multiple views. In this case there must be sufficient budget for all charges or the query is rejected and charges are refunded in best effort. The budget does not have a refresh policy and can only be updated via ALTER VIEW or circumvented by creating a new view that can be queried with a fresh budget. - `deltaBudgetRemaining` number, double: Output only. The delta budget remaining. If budget is exhausted, no more queries are allowed. Note that the budget for queries that are in progress is deducted before the query executes. If the query fails or is cancelled then the budget is refunded. In this case the amount of budget remaining can increase. - `deltaPerQuery` number, double: Optional. The delta value that is used per query. Delta represents the probability that any row will fail to be epsilon differentially private. Indicates the risk associated with exposing aggregate rows in the result of a query. - `epsilonBudget` number, double: Optional. The total epsilon budget for all queries against the privacy-protected view. Each subscriber query against this view charges the amount of epsilon they request in their query. If there is sufficient budget, then the subscriber query attempts to complete. It might still fail due to other reasons, in which case the charge is refunded. If there is insufficient budget the query is rejected. There might be multiple charge attempts if a single query references multiple views. In this case there must be sufficient budget for all charges or the query is rejected and charges are refunded in best effort. The budget does not have a refresh policy and can only be updated via ALTER VIEW or circumvented by creating a new view that can be queried with a fresh budget. - `epsilonBudgetRemaining` number, double: Output only. The epsilon budget remaining. If budget is exhausted, no more queries are allowed. Note that the budget for queries that are in progress is deducted before the query executes. If the query fails or is cancelled then the budget is refunded. In this case the amount of budget remaining can increase. - `maxEpsilonPerQuery` number, double: Optional. The maximum epsilon value that a query can consume. If the subscriber specifies epsilon as a parameter in a SELECT query, it must be less than or equal to this value. The epsilon parameter controls the amount of noise that is added to the groups — a higher epsilon means less noise. - `maxGroupsContributed` string, int64: Optional. The maximum groups contributed value that is used per query. Represents the maximum number of groups to which each protected entity can contribute. Changing this value does not improve or worsen privacy. The best value for accuracy and utility depends on the query and data. - `privacyUnitColumn` string: Optional. The privacy unit column associated with this policy. Differential privacy policies can only have one privacy unit column per data source object (table, view). - `joinRestrictionPolicy` JoinRestrictionPolicy: Represents privacy policy associated with "join restrictions". Join restriction gives data providers the ability to enforce joins on the 'join_allowed_columns' when data is queried from a privacy protected view. - `joinAllowedColumns` string[]: Optional. The only columns that joins are allowed on. This field is must be specified for join_conditions JOIN_ANY and JOIN_ALL and it cannot be set for JOIN_BLOCKED. - `joinCondition` 'JOIN_CONDITION_UNSPECIFIED' | 'JOIN_ANY' | 'JOIN_ALL' | 'JOIN_NOT_REQUIRED' | 'JOIN_BLOCKED': Optional. Specifies if a join is required or not on queries for the view. Default is JOIN_CONDITION_UNSPECIFIED. - `useLegacySql` boolean: True if view is defined in legacy SQL dialect, false if in GoogleSQL. - `totalItems` integer: The total number of tables in the dataset. ## Changes - **2026-11-05** `33188b5cf151`: 4 info - the security scope `https://www.googleapis.com/auth/bigquery` was added to the endpoint's security scheme `Oauth2` - the security scope `https://www.googleapis.com/auth/bigquery` was added to the endpoint's security scheme `Oauth2c` - the security scope `https://www.googleapis.com/auth/cloud-platform.read-only` was removed from the endpoint's security scheme `Oauth2` - the security scope `https://www.googleapis.com/auth/cloud-platform.read-only` was removed from the endpoint's security scheme `Oauth2c` - **2026-10-29** `1c22958240fa`: 4 info - the security scope `https://www.googleapis.com/auth/bigquery` was added to the endpoint's security scheme `Oauth2` - the security scope `https://www.googleapis.com/auth/bigquery` was added to the endpoint's security scheme `Oauth2c` - the security scope `https://www.googleapis.com/auth/cloud-platform.read-only` was removed from the endpoint's security scheme `Oauth2` - the security scope `https://www.googleapis.com/auth/cloud-platform.read-only` was removed from the endpoint's security scheme `Oauth2c` [Operation history](https://skmtc.dev/google/apis/bigquery/changes/projects/:projectsId/datasets/:datasetsId/tables/get.md) --- [API](https://skmtc.dev/google/apis/bigquery.md) - [All operations](https://skmtc.dev/google/apis/bigquery/llms.txt) - [OpenAPI document](https://skmtc.dev/google/apis/bigquery/revisions/33188b5cf151?raw)