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;

Schema for turbot_resource_type

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
akas	jsonb		AKA (also known as) identifiers for the resource type.
category_id	bigint		ID of the resource category for the resource type.
category_uri	text	=	URI of the resource category for the resource type.
create_timestamp	timestamp with time zone		When the resource type was first discovered by Turbot. (It may have been created earlier.)
description	text		Description of the resource type.
icon	text		Icon of the resource type.
id	bigint	=	Unique identifier of the resource type.
mod_uri	text		URI of the mod that contains the resource type.
parent_id	bigint		ID for the parent of this resource type.
path	jsonb		Hierarchy path with all identifiers of ancestors of the resource type.
title	text		Title of the resource type.
trunk_title	text		Title with full path of the resource type.
update_timestamp	timestamp with time zone		When the resource type was last updated in Turbot.
uri	text	=	URI of the resource type.
version_id	bigint		Unique identifier for this version of the resource type.
workspace	text		Specifies the workspace URL.