turbot/steampipe-mod-aws-insights

Query: codepipeline_pipelines_for_codecommit_repository

Usage

powerpipe query aws_insights.query.codepipeline_pipelines_for_codecommit_repository

SQL

select
p.arn as codepipeline_pipeline_arn
from
aws_codecommit_repository r
cross join aws_codepipeline_pipeline as p
where
r.arn = $1
and r.account_id = split_part($1, ':', 5)
and r.region = split_part($1, ':', 4)
and p.stages is not null
and r.repository_name in (
select
jsonb_path_query(
p.stages,
'$[*].Actions[*].Configuration.RepositoryName'
) :: text
);