Query: vpc_security_groups_for_codebuild_project

with sg_id as (
  select
    vpc_config -> 'SecurityGroupIds' as sg,
    arn
  from
    aws_codebuild_project
)
select
  s.group_id as vpc_security_group_id
from
  sg_id as c,
  aws_vpc_security_group as s
where
  sg ? & array [ s.group_id ]
  and c.arn = $1;