steampipe plugin install aws

Table: aws_ec2_transit_gateway_route_table - Query AWS EC2 Transit Gateway Route Tables using SQL

The AWS EC2 Transit Gateway Route Table is a component of Amazon's Elastic Compute Cloud (EC2) service that allows you to manage routing for your Transit Gateways. It facilitates the control of traffic between different networks within your cloud environment. Using this resource, you can define rules that determine the path network traffic takes to reach a specific destination.

Table Usage Guide

The aws_ec2_transit_gateway_route_table table in Steampipe provides you with information about each route table associated with a transit gateway within your Amazon Elastic Compute Cloud (EC2). This table allows you, as a DevOps engineer, to query route table-specific details, including the transit gateway ID, route table ID, state, and associated tags. You can utilize this table to gather insights on transit gateway route tables, such as their current state, associated transit gateways, and more. The schema outlines the various attributes of the transit gateway route table for you, including the route table ID, transit gateway ID, creation time, and associated tags.

Examples

Basic transit gateway route table info

Explore the fundamental characteristics of your transit gateway route tables in AWS EC2. This query is useful in understanding the default associations and propagations within your route tables, aiding in efficient network management.

select
transit_gateway_route_table_id,
transit_gateway_id,
default_association_route_table,
default_propagation_route_table
from
aws_ec2_transit_gateway_route_table;
select
transit_gateway_route_table_id,
transit_gateway_id,
default_association_route_table,
default_propagation_route_table
from
aws_ec2_transit_gateway_route_table;

Count of transit gateway route table by transit gateway

Explore which transit gateways are associated with numerous route tables in your AWS EC2 service. This can be useful for optimizing network routing paths and managing network resources effectively.

select
transit_gateway_id,
count(transit_gateway_route_table_id) as transit_gateway_route_table_count
from
aws_ec2_transit_gateway_route_table
group by
transit_gateway_id;
select
transit_gateway_id,
count(transit_gateway_route_table_id) as transit_gateway_route_table_count
from
aws_ec2_transit_gateway_route_table
group by
transit_gateway_id;

Schema for aws_ec2_transit_gateway_route_table

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
creation_timetimestamp with time zoneThe creation time of transit gateway route table.
default_association_route_tableboolean=Indicates whether this is the default association route table for the transit gateway.
default_propagation_route_tableboolean=Indicates whether this is the default propagation route table for the transit gateway.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetext=The state of the transit gateway route table.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags assigned.
titletextTitle of the resource.
transit_gateway_idtext=The ID of the transit gateway.
transit_gateway_route_table_idtext=The ID of the transit gateway route table.

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_table