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
      and region = split_part($1, ':', 4)
      and account_id = split_part($1, ':', 5)
  );