Table: turbot_tag

Tags is a unified collection of all tags discovered by Turbot across all resources in all clouds.

It is recommended that queries to this table should include (usually in the where clause) at least one of these columns: id, key, value or filter.

Examples

List all tags

select
  *
from
  turbot_tag
order by
  key,
  value;

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 tags without values

select
  *
from
  turbot_tag
where
  value is null
  or trim(value) = '';