turbot/turbot

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

Table: turbot_control_type

List all the cloud control types known to Turbot.

Examples

List all control types

select
id,
uri,
trunk_title
from
turbot_control_type
order by
trunk_title

List all control types for AWS S3

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

Count control 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_control_type

Control types that target AWS > S3 > Bucket

select
trunk_title,
uri,
targets
from
turbot_control_type
where
targets ? 'tmod:@turbot/aws-s3#/resource/types/bucket'

.inspect turbot_control_type

Control types define the types of controls known to Turbot.

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