Skip to content
AWS for Query.Farm

aws.route53resolver.get_resolver_endpoint

Example SQL Queries

SELECT * FROM
aws.route53resolver.get_resolver_endpoint
WHERE
"resolver_endpoint_id" = 'VALUE';

Description

Gets information about a specified Resolver endpoint, such as whether it's an inbound or an outbound Resolver endpoint, and the current status of the endpoint.

Table Definition

Column NameColumn Data Type
resolver_endpoint_id Required Input Column

The ID of the Resolver endpoint that you want to get information about.

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
resolver_endpoint

Information about the Resolver endpoint that you specified in a GetResolverEndpoint request.

STRUCT(
    "id" VARCHAR,
    "creator_request_id" VARCHAR,
    "arn" VARCHAR,
    "name" VARCHAR,
    "security_group_ids" VARCHAR[],
    "direction" VARCHAR,
    "ip_address_count" BIGINT,
    "host_vpc_id" VARCHAR,
    "status" VARCHAR,
    "status_message" VARCHAR,
    "creation_time" VARCHAR,
    "modification_time" VARCHAR,
    "outpost_arn" VARCHAR,
    "preferred_instance_type" VARCHAR,
    "resolver_endpoint_type" VARCHAR,
    "protocols" VARCHAR[]
)
Show child fields
resolver_endpoint.arn

The ARN (Amazon Resource Name) for the Resolver endpoint.

resolver_endpoint.creation_time

The date and time that the endpoint was created, in Unix time format and Coordinated Universal Time (UTC).

resolver_endpoint.creator_request_id

A unique string that identifies the request that created the Resolver endpoint. The CreatorRequestId allows failed requests to be retried without the risk of running the operation twice.

resolver_endpoint.direction

Indicates whether the Resolver endpoint allows inbound or outbound DNS queries:

  • INBOUND: allows DNS queries to your VPC from your network

  • OUTBOUND: allows DNS queries from your VPC to your network

resolver_endpoint.host_vpc_id

The ID of the VPC that you want to create the Resolver endpoint in.

resolver_endpoint.id

The ID of the Resolver endpoint.

resolver_endpoint.ip_address_count

The number of IP addresses that the Resolver endpoint can use for DNS queries.

resolver_endpoint.modification_time

The date and time that the endpoint was last modified, in Unix time format and Coordinated Universal Time (UTC).

resolver_endpoint.name

The name that you assigned to the Resolver endpoint when you submitted a CreateResolverEndpoint request.

resolver_endpoint.outpost_arn

The ARN (Amazon Resource Name) for the Outpost.

resolver_endpoint.preferred_instance_type

The Amazon EC2 instance type.

resolver_endpoint.protocols[]
resolver_endpoint.resolver_endpoint_type

The Resolver endpoint IP address type.

resolver_endpoint.security_group_ids[]
resolver_endpoint.status

A code that specifies the current status of the Resolver endpoint. Valid values include the following:

  • CREATING: Resolver is creating and configuring one or more Amazon VPC network interfaces for this endpoint.

  • OPERATIONAL: The Amazon VPC network interfaces for this endpoint are correctly configured and able to pass inbound or outbound DNS queries between your network and Resolver.

  • UPDATING: Resolver is associating or disassociating one or more network interfaces with this endpoint.

  • AUTO_RECOVERING: Resolver is trying to recover one or more of the network interfaces that are associated with this endpoint. During the recovery process, the endpoint functions with limited capacity because of the limit on the number of DNS queries per IP address (per network interface). For the current limit, see Limits on Route 53 Resolver.

  • ACTION_NEEDED: This endpoint is unhealthy, and Resolver can't automatically recover it. To resolve the problem, we recommend that you check each IP address that you associated with the endpoint. For each IP address that isn't available, add another IP address and then delete the IP address that isn't available. (An endpoint must always include at least two IP addresses.) A status of ACTION_NEEDED can have a variety of causes. Here are two common causes:

    • One or more of the network interfaces that are associated with the endpoint were deleted using Amazon VPC.

    • The network interface couldn't be created for some reason that's outside the control of Resolver.

  • DELETING: Resolver is deleting this endpoint and the associated network interfaces.

resolver_endpoint.status_message

A detailed description of the status of the Resolver endpoint.