turbot_resource_type.md

Table: turbot_resource_type

List all the cloud resource types known to Turbot.

Examples

List all resource types

select
  id,
  uri,
  trunk_title
from
  turbot_resource_type
order by
  trunk_title;

List all resource types for AWS S3

select
  id,
  uri,
  trunk_title
from
  turbot_resource_type
where
  mod_uri like 'tmod:@turbot/aws-s3%'
order by
  trunk_title;

Count resource types by cloud provider

select
  sum(case when mod_uri like 'tmod:@turbot/aws-%' then 1 else 0 end) as aws,
  sum(case when mod_uri like 'tmod:@turbot/azure-%' then 1 else 0 end) as azure,
  sum(case when mod_uri like 'tmod:@turbot/gcp-%' then 1 else 0 end) as gcp,
  count(*) as total
from
  turbot_resource_type;