Tables
To view the list of tables and views
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 rest of the filter is executed client side within the add-in.
- DataSetName supports the 'CONTAINS' comparison.
- Type supports the '=' comparison.
- ProjectId supports the '=' comparison.
- EntryGroup supports the '=' comparison.
- CreatedTime supports the '=, <, <=, >, >=' comparisons.
- UpdatedTime supports the '=, <, <=, >, >=' comparisons.
- OrganizationId supports the '=' comparison.
- TagName supports the 'CONTAINS' comparison.
- DisplayName supports the 'CONTAINS' comparison.
- SearchColumn supports the 'CONTAINS' comparison.
- Description supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM Tables WHERE UpdatedTime <= '2018-06-01 11:00:00.0' SELECT * FROM Tables WHERE UpdatedTime >= '2018-06-01' SELECT * FROM Tables WHERE UpdatedTime > '2018-06-01 12:00:00' AND CreatedTime < '2019-06-01 11:00:00' SELECT * FROM Tables WHERE OrganizationId = '112025358' SELECT * FROM Tables WHERE ProjectId = 'bigquery-public-data' SELECT * FROM Tables WHERE CONTAINS (SearchColumn, 'name') SELECT * FROM Tables WHERE TagName = 'test' SELECT * FROM Tables WHERE Type = 'table' OR Type = 'view'
Additionally LastAccessedTime and UpdatedTime columns can be used in the ORDER BY clause, as following:
SELECT * FROM Tables ORDER BY LastAccessed DESC SELECT * FROM Tables ORDER BY UpdatedTime ASC
Columns
| Name | Type | Description |
| DataSetName | String | Dataset name in the project. |
| TableName | String | Tables in the dataset. |
| Type | String | Table type of either table or view.
The allowed values are table, view. |
| ProjectId | String | The project which the table created in. |
| Region | String | The cloud location of the table. |
| EntryGroup | String | The source dataset type.
The allowed values are bigquery, cloud_pubsub, data_catalog. |
| ResourceName | String | Resource name of the table. |
| OrganizationId | String | The Organization which the dataset created in. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| TagName | String | Filter by tagname in the tables. |
| CreatedTime | Datetime | Filter by table created time. |
| UpdatedTime | Datetime | Filter by table updated time. |
| DisplayName | String | Display name of the table. |
| SearchColumn | String | Search columns in the list of tables by column name. |
| Description | String | Description of the table. |
| LastAccessed | String | Sort the response by last accessed datetime. |