Skip to content
AWS for Query.Farm

aws.globalaccelerator.list_custom_routing_port_mappings_by_destination

Example SQL Queries

SELECT * FROM
aws.globalaccelerator.list_custom_routing_port_mappings_by_destination
WHERE
"endpoint_id" = 'VALUE'
AND "destination_address" = 'VALUE';

Description

List the port mappings for a specific EC2 instance (destination) in a VPC subnet endpoint. The response is the mappings for one destination IP address. This is useful when your subnet endpoint has mappings that span multiple custom routing accelerators in your account, or for scenarios where you only want to list the port mappings for a specific destination instance.

Table Definition

Column NameColumn Data Type
destination_address Required Input Column

The endpoint IP address in a virtual private cloud (VPC) subnet for which you want to receive back port mappings.

VARCHAR
endpoint_id Required Input Column

The ID for the virtual private cloud (VPC) subnet.

VARCHAR
_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.

_aws_region Input Column

The AWS region to use.

VARCHAR
accelerator_arn

The Amazon Resource Name (ARN) of the custom routing accelerator that you have port mappings for.

VARCHAR
accelerator_socket_addresses

The IP address/port combinations (sockets) that map to a given destination socket address.

STRUCT(
    "ip_address" VARCHAR,
    "port" BIGINT
)[]
Show child fields
accelerator_socket_addresses[]
Show child fields
accelerator_socket_addresses[].ip_address

The IP address for the socket address.

accelerator_socket_addresses[].port

The port for the socket address.

destination_socket_address

The endpoint IP address/port combination for traffic received on the accelerator socket address.

STRUCT(
    "ip_address" VARCHAR,
    "port" BIGINT
)
Show child fields
destination_socket_address.ip_address

The IP address for the socket address.

destination_socket_address.port

The port for the socket address.

destination_traffic_state

Indicates whether or not a port mapping destination can receive traffic. The value is either ALLOW, if traffic is allowed to the destination, or DENY, if traffic is not allowed to the destination.

VARCHAR
endpoint_group_arn

The Amazon Resource Name (ARN) of the endpoint group.

VARCHAR
endpoint_group_region

The Amazon Web Services Region for the endpoint group.

VARCHAR
ip_address_type

The IP address type that an accelerator supports. For a custom routing accelerator, the value must be IPV4.

VARCHAR