turbot/aws_insights

Query: ecr_repositories_for_codebuild_project

Usage

powerpipe query aws_insights.query.ecr_repositories_for_codebuild_project

SQL

select
r.arn as ecr_repository_arn
from
aws_codebuild_project as p
left join aws_ecr_repository as r on r.repository_uri = split_part(p.environment ->> 'Image', ':', 1)
where
r.arn is not null
and p.arn = $1;