turbot/aws_insights

Query: vpc_subnets_for_rds_db_instance

Usage

powerpipe query aws_insights.query.vpc_subnets_for_rds_db_instance

Steampipe Tables

SQL

select
subnet ->> 'SubnetIdentifier' as subnet_id
from
aws_rds_db_instance as rdb,
jsonb_array_elements(subnets) as subnet
where
rdb.arn = $1
and rdb.account_id = split_part($1, ':', 5)
and rdb.region = split_part($1, ':', 4);