To view the list of TagTemplates in the project

Table Specific Information

Select

The connector 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 connector.

• Name supports the 'CONTAINS' comparison.
• Type supports the '=' comparison.
• ProjectId supports the '=' comparison.
• CreatedTime supports the '=, <, <=, >, >=' comparisons.
• UpdatedTime supports the '=, <, <=, >, >=' comparisons.
• OrganizationId supports the '=' comparison.
• DisplayName supports the 'CONTAINS' comparison.

For example, the following queries are processed server side:

SELECT * FROM TagTemplates WHERE OrganizationId = '112025358'

SELECT * FROM TagTemplates WHERE CONTAINS (Name, 'test') OR ProjectId = 'bigquery-public-data'

SELECT * FROM TagTemplates WHERE CreatedTime >= '2018-01-01 01:00:00'

SELECT * FROM TagTemplates WHERE UpdatedTime < '2018-06-01'

SELECT * FROM TagTemplates WHERE UpdatedTime > '2018-06-01 12:00:00' AND CreatedTime <= '2019-06-01 11:00'

SELECT * FROM TagTemplates WHERE Type = 'tag_template' AND DisplayName = 'test_template'

Additionally LastAccessedTime and UpdatedTime columns can be used in the ORDER BY clause, as following:

SELECT * FROM TagTemplates ORDER BY LastAccessed ASC

SELECT * FROM TagTemplates ORDER BY UpdatedTime DESC

Columns

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.