turbot/oci_insights

Query: vcn_route_table

Usage

powerpipe query oci_insights.query.vcn_route_table

Steampipe Tables

SQL

select
display_name as "Route Table Name",
lifecycle_state as "Lifecycle State",
r ->> 'cidrBlock' as "CIDR Block",
r ->> 'destination' as "Destination",
r ->> 'destinationType' as "Destination Type",
r ->> 'networkEntityId' as "Network Entity ID"
from
oci_core_route_table,
jsonb_array_elements(route_rules) as r
where
vcn_id = $1
order by
display_name;

Dashboards

The query is used in the dashboards: