turbot/aws_insights

Query: iam_roles_for_rds_db_cluster

Usage

powerpipe query aws_insights.query.iam_roles_for_rds_db_cluster

Steampipe Tables

SQL

select
roles ->> 'RoleArn' as role_arn
from
aws_rds_db_cluster
cross join jsonb_array_elements(associated_roles) as roles
where
arn = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4);