Table: turbot_control_type
List all the cloud control types known to Turbot.
Examples
List all control types
select id, uri, trunk_titlefrom turbot_control_typeorder by trunk_title;
List all control types for AWS S3
select id, uri, trunk_titlefrom turbot_control_typewhere 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 totalfrom turbot_control_type;
Control types that target AWS > S3 > Bucket
select trunk_title, uri, targetsfrom turbot_control_typewhere targets ? 'tmod:@turbot/aws-s3#/resource/types/bucket';
Schema for turbot_control_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 control type. | |
category_id | bigint | ID of the control category for the control type. | |
category_uri | text | = | URI of the control category for the control type. |
create_timestamp | timestamp with time zone | When the control type was first discovered by Turbot. (It may have been created earlier.) | |
description | text | Description of the control type. | |
icon | text | Icon of the control type. | |
id | bigint | = | Unique identifier of the control type. |
mod_uri | text | URI of the mod that contains the control type. | |
parent_id | text | ID for the parent of this control type. | |
path | jsonb | Hierarchy path with all identifiers of ancestors of the control type. | |
targets | jsonb | URIs of the resource types targeted by this control type. | |
title | text | Title of the control type. | |
trunk_title | text | Title with full path of the control type. | |
update_timestamp | timestamp with time zone | When the control type was last updated in Turbot. | |
uri | text | = | URI of the control type. |
version_id | bigint | Unique identifier for this version of the control type. | |
workspace | text | Specifies the workspace URL. |