turbot/turbot

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

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

.inspect turbot_resource_type

Resource types define the types of resources known to Turbot.

NameTypeDescription
akasjsonbAKA (also known as) identifiers for the resource type.
category_idbigintID of the resource category for the resource type.
category_uritextURI of the resource category for the resource type.
create_timestamptimestamp without time zoneWhen the resource type was first discovered by Turbot. (It may have been created earlier.)
descriptiontextDescription of the resource type.
icontextIcon of the resource type.
idbigintUnique identifier of the resource type.
mod_uritextURI of the mod that contains the resource type.
parent_idbigintID for the parent of this resource type.
pathjsonbHierarchy path with all identifiers of ancestors of the resource type.
titletextTitle of the resource type.
trunk_titletextTitle with full path of the resource type.
update_timestamptimestamp without time zoneWhen the resource type was last updated in Turbot.
uritextURI of the resource type.
version_idbigintUnique identifier for this version of the resource type.