turbot/aws_insights

Query: vpc_nat_gateways_for_ec2_network_interface

Usage

powerpipe query aws_insights.query.vpc_nat_gateways_for_ec2_network_interface

Steampipe Tables

SQL

select
arn as gateway_arn
from
aws_vpc_nat_gateway,
jsonb_array_elements(nat_gateway_addresses) as a
where
a ->> 'NetworkInterfaceId' = $1;