steampipe plugin install aws

Table: aws_ec2_transit_gateway_route - Query AWS EC2 Transit Gateway Routes using SQL

The AWS EC2 Transit Gateway Routes enable you to manage connectivity between multiple Virtual Private Clouds (VPCs) and on-premises networks by acting as a hub. They simplify network architecture by reducing the number of connections required to connect multiple VPCs and on-premises networks. Transit Gateway Routes also provide flexible routing policies to support various types of network architectures.

Table Usage Guide

The aws_ec2_transit_gateway_route table in Steampipe provides you with information about the routes in each transit gateway within AWS EC2. This table allows you, as a DevOps engineer, to query route-specific details, including the destination CIDR block, the route's current state, and the transit gateway attachments. You can utilize this table to gather insights on routes, such as verifying the transit gateway route's state, checking the destination CIDR block, and more. The schema outlines the various attributes of the transit gateway route for you, including the transit gateway route ID, transit gateway route destination CIDR block, and associated tags.

Examples

Basic info

Explore the configuration of your AWS EC2 transit gateway routes to understand their current state and type. This can help you identify potential network routing issues or areas for optimization.

select
transit_gateway_route_table_id,
destination_cidr_block,
prefix_list_id,
state,
type
from
aws_ec2_transit_gateway_route;
select
transit_gateway_route_table_id,
destination_cidr_block,
prefix_list_id,
state,
type
from
aws_ec2_transit_gateway_route;

List active routes

Explore which transit gateway routes are currently active to manage network traffic effectively. This is useful for maintaining network efficiency and ensuring optimal route configurations.

select
transit_gateway_route_table_id,
destination_cidr_block,
state,
type
from
aws_ec2_transit_gateway_route
where
state = 'active';
select
transit_gateway_route_table_id,
destination_cidr_block,
state,
type
from
aws_ec2_transit_gateway_route
where
state = 'active';

Schema for aws_ec2_transit_gateway_route

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
destination_cidr_blockcidrThe CIDR block used for destination matches.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
prefix_list_idtext=The ID of the prefix list used for destination matches.
regiontextThe AWS Region in which the resource is located.
statetext=The state of the route.
titletextTitle of the resource.
transit_gateway_attachmentsjsonbThe attachments.
transit_gateway_route_table_idtextThe ID of the transit gateway route table.
typetext=The route type.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_ec2_transit_gateway_route