turbot/aws_insights

Query: vpc_vpcs_for_sqs_queue

Usage

powerpipe query aws_insights.query.vpc_vpcs_for_sqs_queue

Steampipe Tables

SQL

select
vpc_id
from
aws_vpc_endpoint,
jsonb_array_elements(policy_std -> 'Statement') as s,
jsonb_array_elements_text(s -> 'Resource') as r
where
r = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4)