Skip to content
AWS for Query.Farm

aws.networkmanager.get_network_routes

Example SQL Queries

SELECT * FROM
aws.networkmanager.get_network_routes
WHERE
"global_network_id" = 'VALUE'
AND "route_table_identifier" = 'VALUE';

Description

Gets the network routes of the specified global network.

Table Definition

Column NameColumn Data Type
global_network_id Required Input Column

The ID of the global network.

VARCHAR
route_table_identifier Required Input Column

The ID of the route table.

STRUCT(
    "transit_gateway_route_table_arn" VARCHAR,
    "core_network_segment_edge" STRUCT(
        "core_network_id" VARCHAR,
        "segment_name" VARCHAR,
        "edge_location" VARCHAR
    ),
    "core_network_network_function_group" STRUCT(
        "core_network_id" VARCHAR,
        "network_function_group_name" VARCHAR,
        "edge_location" VARCHAR
    )
)
Show child fields
route_table_identifier.core_network_network_function_group

The route table identifier associated with the network function group.

Show child fields
route_table_identifier.core_network_network_function_group.core_network_id

The ID of the core network.

route_table_identifier.core_network_network_function_group.edge_location

The location for the core network edge.

route_table_identifier.core_network_network_function_group.network_function_group_name

The network function group name.

route_table_identifier.core_network_segment_edge

The segment edge in a core network.

Show child fields
route_table_identifier.core_network_segment_edge.core_network_id

The ID of a core network.

route_table_identifier.core_network_segment_edge.edge_location

The Region where the segment edge is located.

route_table_identifier.core_network_segment_edge.segment_name

The name of the segment edge.

route_table_identifier.transit_gateway_route_table_arn

The ARN of the transit gateway route table for the attachment request. For example, "TransitGatewayRouteTableArn": "arn:aws:ec2:us-west-2:123456789012:transit-gateway-route-table/tgw-rtb-9876543210123456".

destination_filters Input Column

Filter by route table destination. Possible Values: TRANSIT_GATEWAY_ATTACHMENT_ID, RESOURCE_ID, or RESOURCE_TYPE.

MAP(VARCHAR, VARCHAR[])
exact_cidr_matches Input Column

An exact CIDR block.

VARCHAR[]
Show child fields
exact_cidr_matches[]
longest_prefix_matches Input Column

The most specific route that matches the traffic (longest prefix match).

VARCHAR[]
Show child fields
longest_prefix_matches[]
prefix_list_ids Input Column

The IDs of the prefix lists.

VARCHAR[]
Show child fields
prefix_list_ids[]
states Input Column

The route states.

VARCHAR[]
Show child fields
states[]
subnet_of_matches Input Column

The routes with a subnet that match the specified CIDR filter.

VARCHAR[]
Show child fields
subnet_of_matches[]
supernet_of_matches Input Column

The routes with a CIDR that encompasses the CIDR filter. Example: If you specify 10.0.1.0/30, then the result returns 10.0.1.0/29.

VARCHAR[]
Show child fields
supernet_of_matches[]
types Input Column

The route types.

VARCHAR[]
Show child fields
types[]
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

core_network_segment_edge

Describes a core network segment edge.

STRUCT(
    "core_network_id" VARCHAR,
    "segment_name" VARCHAR,
    "edge_location" VARCHAR
)
Show child fields
core_network_segment_edge.core_network_id

The ID of a core network.

core_network_segment_edge.edge_location

The Region where the segment edge is located.

core_network_segment_edge.segment_name

The name of the segment edge.

network_routes

The network routes.

STRUCT(
    "destination_cidr_block" VARCHAR,
    "destinations" STRUCT(
        "core_network_attachment_id" VARCHAR,
        "transit_gateway_attachment_id" VARCHAR,
        "segment_name" VARCHAR,
        "network_function_group_name" VARCHAR,
        "edge_location" VARCHAR,
        "resource_type" VARCHAR,
        "resource_id" VARCHAR
    )[],
    "prefix_list_id" VARCHAR,
    "state" VARCHAR,
    "type" VARCHAR
)[]
Show child fields
network_routes[]
Show child fields
network_routes[].destination_cidr_block

A unique identifier for the route, such as a CIDR block.

network_routes[].destinations[]
Show child fields
network_routes[].destinations[].core_network_attachment_id

The ID of a core network attachment.

network_routes[].destinations[].edge_location

The edge location for the network destination.

network_routes[].destinations[].network_function_group_name

The network function group name associated with the destination.

network_routes[].destinations[].resource_id

The ID of the resource.

network_routes[].destinations[].resource_type

The resource type.

network_routes[].destinations[].segment_name

The name of the segment.

network_routes[].destinations[].transit_gateway_attachment_id

The ID of the transit gateway attachment.

network_routes[].prefix_list_id

The ID of the prefix list.

network_routes[].state

The route state. The possible values are active and blackhole.

network_routes[].type

The route type. The possible values are propagated and static.

route_table_arn

The ARN of the route table.

VARCHAR
route_table_timestamp

The route table creation time.

TIMESTAMP_S
route_table_type

The route table type.

VARCHAR