turbot/aws_insights

Query: codebuild_project_sources

Usage

powerpipe query aws_insights.query.codebuild_project_sources

Steampipe Tables

SQL

with sources as (
select
source,
secondary_sources
from
aws_codebuild_project
where
account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4)
and arn = $1
)
select
source ->> 'Type' as "Type",
source ->> 'Location' as "Location",
source ->> 'GitCloneDepth' as "Clone Depth"
from
sources
union all
select
s ->> 'Type' as "Type",
s ->> 'Location' as "Location",
s ->> 'GitCloneDepth' as "Clone Depth"
from
sources,
jsonb_array_elements(secondary_sources) as s;

Dashboards

The query is used in the dashboards: