turbot/aws_insights

Query: emr_clusters_for_iam_role

Usage

powerpipe query aws_insights.query.emr_clusters_for_iam_role

SQL

select
c.cluster_arn as cluster_arn
from
aws_iam_role as r,
aws_emr_cluster as c
where
r.arn = $1
and r.account_id = split_part($1, ':', 5)
and r.name = c.service_role;