Tableau Connector for Google Data Catalog

Build 21.0.7930

TagTemplates

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

Name Type Description
Name String TagTemplate name in the project.
Type String TagTemplate type.

The allowed values are tag_template.

ProjectId String The project which the TagTemplate created.
Location String The cloud location of the project.
ResourceName String The TagTemplate ResourceName.
OrganizationId String The Organization which the TagTemplate created.

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
CreatedTime Datetime Filter by TagTemplate created time.
UpdatedTime Datetime Filter by table updated time.
DisplayName String Display name of the TagTemplate.
LastAccessed String Sort the response by last accessed datetime.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930