JDBC Driver for Google Data Catalog

Build 24.0.9062

TagTemplates

To view the list of TagTemplates in the project

Table Specific Information

Select

The 本製品 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 本製品.

  • 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.

使用できる値は次のとおりです。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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062