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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The AWS 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 creation time of transit gateway route table.
default_association_route_table	boolean	=	Indicates whether this is the default association route table for the transit gateway.
default_propagation_route_table	boolean	=	Indicates whether this is the default propagation route table for the transit gateway.
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text		The AWS Region in which the resource is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text	=	The state of the transit gateway route table.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		A list of tags assigned.
title	text		Title of the resource.
transit_gateway_id	text	=	The ID of the transit gateway.
transit_gateway_route_table_id	text	=	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