Tags is a unified collection of all tags discovered by Turbot across all resources in all clouds.
Queries to this table must specify (usually in the
where clause) at least one
of these columns:
Find all resources for the Sales department
selectkey,value,resource_idsfromturbot_tagwherekey = 'Department'and value = 'Sales'
Find departments with the most tagged resources
selectkey,value,jsonb_array_length(resource_ids) as countfromturbot_tagwherekey = 'Department'order bycount desc
List all tags
select*fromturbot_tagwhere-- At least one qualifier must be given, return all with filter = ''filter = ''order bykey,value
All tags discovered on cloud resources by Turbot.
|create_timestamp||timestamp without time zone||When the tag was first discovered by Turbot. (It may have been created earlier.)|
|filter||text||Filter used for this tag list.|
|id||bigint||Unique identifier of the tag.|
|resource_ids||jsonb||Turbot IDs of resources with this tag.|
|timestamp||timestamp without time zone||Timestamp when the tag was last modified (created, updated or deleted).|
|update_timestamp||timestamp without time zone||When the tag was last updated in Turbot.|
|version_id||bigint||Unique identifier for this version of the tag.|