turbot/azure_insights

Query: network_route_tables_for_network_subnet

Usage

powerpipe query azure_insights.query.network_route_tables_for_network_subnet

Steampipe Tables

SQL

select
lower(r.id) as route_table_id
from
azure_route_table as r,
jsonb_array_elements(r.subnets) as sub
where
lower(sub ->> 'id') = $1;