turbot/alicloud

steampipe plugin install alicloudsteampipe plugin install alicloud

Table: alicloud_vpc_route_table

A route table contains a set of rules, called routes, that are used to determine where network traffic from your subnet or gateway is directed.

Examples

Basic info

select
name,
route_table_id,
description,
route_table_type,
router_id,
region
from
alicloud_vpc_route_table;

Get VPC and VSwitch attachment info for each route table

select
name,
route_table_id,
vpc_id,
jsonb_array_elements_text(vswitch_ids)
from
alicloud_vpc_route_table;

Routing details for each route table

select
route_table_id,
route_detail ->> 'Description' as description,
route_detail ->> 'DestinationCidrBlock' as destination_CIDR_block,
route_detail ->> 'InstanceId' as instance_id,
route_detail ->> 'IpVersion' as ip_version,
route_detail ->> 'NextHopOppsiteInstanceId' as next_hop_oppsite_instance_id,
route_detail ->> 'NextHopOppsiteRegionId' as next_hop_oppsite_region_id,
route_detail ->> 'NextHopOppsiteType' as next_hop_oppsite_type,
route_detail ->> 'NextHopRegionId' as next_hop_region_id,
route_detail ->> 'NextHopType' as next_hop_type,
route_detail ->> 'RouteEntryId' as route_entry_id,
route_detail ->> 'RouteEntryName' as route_entry_name,
route_detail ->> 'RouteTableId' as route_table_id,
route_detail ->> 'Status' as status
from
alicloud_vpc_route_table,
jsonb_array_elements(route_entries) as route_detail;

List route tables without application tag key

select
name,
route_table_id
from
alicloud_vpc_route_table
where
not tags :: JSONB ? 'application';

.inspect alicloud_vpc_route_table

Alicloud VPC Route Table

NameTypeDescription
account_idtextThe Alicloud Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
creation_timetimestamp without time zoneThe time when the Route Table was created.
descriptiontextThe description of the Route Table.
nametextThe name of the Route Table.
owner_idtextThe ID of the owner of the VPC.
regiontextThe Alicloud region in which the resource is located.
resource_group_idtextThe ID of the resource group to which the VPC belongs.
route_entriesjsonbRoute entry represents a route item of one VPC route table.
route_table_idtextThe id of the Route Table.
route_table_typetextThe type of Route Table.
router_idtextThe ID of the region to which the VPC belongs.
router_typetextThe type of the VRouter to which the route table belongs. Valid Values are 'VRouter' and 'VBR'.
statustextThe status of the route table.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags assigned to the resource.
titletextTitle of the resource.
vpc_idtextThe ID of the VPC to which the route table belongs.
vswitch_idsjsonbThe unique ID of the VPC.