turbot/aws_insights

Query: vpc_security_groups_for_rds_db_cluster

Usage

powerpipe query aws_insights.query.vpc_security_groups_for_rds_db_cluster

Steampipe Tables

SQL

select
csg ->> 'VpcSecurityGroupId' as group_id
from
aws_rds_db_cluster as c,
jsonb_array_elements(c.vpc_security_groups) as csg
where
c.arn = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4);