Method: tables.get

Gets the specified table resource by table ID. This method does not return the data in the table, it only returns the table resource, which describes the structure of this table.

HTTP request


The URL uses gRPC Transcoding syntax.

Path parameters



Required. Project ID of the requested table



Required. Dataset ID of the requested table



Required. Table ID of the requested table

Query parameters



tabledata.list of table schema fields to return (comma-separated). If unspecified, all fields are returned. A fieldMask cannot be used here because the fields will automatically be converted from camelCase to snake_case and the conversion will fail if there are underscores. Since these are fields in BigQuery table schemas, underscores are allowed.


enum (TableMetadataView)

Optional. Specifies the view that determines which table information is returned. By default, basic table information and storage statistics (STORAGE_STATS) are returned.

Request body

The request body must be empty.

Response body

If successful, the response body contains an instance of Table.

Authorization scopes

Requires one of the following OAuth scopes:


For more information, see the Authentication Overview.


TableMetadataView specifies which table information is returned.

TABLE_METADATA_VIEW_UNSPECIFIED The default value. Default to the STORAGE_STATS view.
BASIC Includes basic table information including schema and partitioning specification. This view does not include storage statistics such as numRows or numBytes. This view is significantly more efficient and should be used to support high query rates.
STORAGE_STATS Includes all information in the BASIC view as well as storage statistics (numBytes, numLongTermBytes, numRows and lastModifiedTime).
FULL Includes all table information, including storage statistics. It returns same information as STORAGE_STATS view, but may contain additional information in the future.