turbot/turbot

steampipe plugin install turbotsteampipe plugin install turbot
On This Page
Get Involved

Table: turbot_tag

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: id, key, value or filter.

Examples

Find all resources for the Sales department

select
key,
value,
resource_ids
from
turbot_tag
where
key = 'Department'
and value = 'Sales'

Find departments with the most tagged resources

select
key,
value,
jsonb_array_length(resource_ids) as count
from
turbot_tag
where
key = 'Department'
order by
count desc

List all tags

select
*
from
turbot_tag
where
-- At least one qualifier must be given, return all with filter = ''
filter = ''
order by
key,
value

.inspect turbot_tag

All tags discovered on cloud resources by Turbot.

NameTypeDescription
create_timestamptimestamp without time zoneWhen the tag was first discovered by Turbot. (It may have been created earlier.)
filtertextFilter used for this tag list.
idbigintUnique identifier of the tag.
keytextTag key.
resource_idsjsonbTurbot IDs of resources with this tag.
timestamptimestamp without time zoneTimestamp when the tag was last modified (created, updated or deleted).
update_timestamptimestamp without time zoneWhen the tag was last updated in Turbot.
valuetextTag value.
version_idbigintUnique identifier for this version of the tag.