Query: codebuild_project_sources

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;