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