turbot/aws_insights

Query: vpc_subnets_for_codebuild_project

Usage

powerpipe query aws_insights.query.vpc_subnets_for_codebuild_project

Steampipe Tables

SQL

select
trim((s :: text), '""') as vpc_subnet_id
from
aws_codebuild_project,
jsonb_array_elements(vpc_config -> 'Subnets') as s
where
arn = $1