TableProperties
To view the properties of the table
Table Specific Information
Select
The add-in will use the Google Data Catalog API to process WHERE clause conditions built with the following column and operator. The ResourceName is required to make a request and the rest of the filter is executed client side within the add-in.
- ResourceName supports the '=' comparison.
SELECT * FROM TableProperties WHERE ResourceName = 'projects/bigquery-public-data/locations/US/entryGroups/@bigquery/entries/cHJvamVjdHMvYmlncXVlcnktcHVibGljLWRhdGEvZGF0YXNldHMvZ2VvX2NlbnN1c19ibG9ja2dyb3Vwcy90YWJsZXMvYmxvY2tncm91cHNfMTE'
Columns
| Name | Type | Description |
| ResourceName [KEY] | String | Resource name of the table. |
| DataSetName | String | The dataset name. |
| TableName | String | Table Name in the dataset. |
| TableSourceType | String | Table datasource. |
| TableCreatedTime | Datetime | Table created time. |
| TableUpdatedTime | Datetime | Table updated time. |
| TableExpiryTime | Datetime | Table expiry time. |