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';

Query examples

.inspect alicloud_vpc_route_table

Alicloud VPC Route Table

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The Alicloud Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
creation_time	timestamp with time zone	The time when the Route Table was created.
description	text	The description of the Route Table.
name	text	The name of the Route Table.
owner_id	text	The ID of the owner of the VPC.
region	text	The Alicloud region in which the resource is located.
resource_group_id	text	The ID of the resource group to which the VPC belongs.
route_entries	jsonb	Route entry represents a route item of one VPC route table.
route_table_id	text	The id of the Route Table.
route_table_type	text	The type of Route Table.
router_id	text	The ID of the region to which the VPC belongs.
router_type	text	The type of the VRouter to which the route table belongs. Valid Values are 'VRouter' and 'VBR'.
status	text	The status of the route table.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags assigned to the resource.
title	text	Title of the resource.
vpc_id	text	The ID of the VPC to which the route table belongs.
vswitch_ids	jsonb	The unique ID of the VPC.

turbot/alicloud

Table: alicloud_vpc_route_table

Examples

Basic info

Get VPC and VSwitch attachment info for each route table

Routing details for each route table

List route tables without application tag key

Query examples

.inspect alicloud_vpc_route_table

Steampipe

Resources

Community