turbot/aws_insights

Query: iam_roles_for_codepipeline_pipeline

Usage

powerpipe query aws_insights.query.iam_roles_for_codepipeline_pipeline

SQL

select
arn as iam_role_arn
from
aws_iam_role
where
arn in
(
select
role_arn
from
aws_codepipeline_pipeline
where
arn = $1
and region = split_part($1, ':', 4)
and account_id = split_part($1, ':', 5)
);