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';

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.