Query: iam_roles_for_codepipeline_pipeline

select
  arn as iam_role_arn
from
  aws_iam_role
where
  arn in (
    select
      role_arn
    from
      aws_codepipeline_pipeline
    where
      arn = $1
  );