Skip to content
AWS for Query.Farm

aws.autoscaling.describe_traffic_sources

Example SQL Queries

SELECT * FROM
aws.autoscaling.describe_traffic_sources
WHERE
"auto_scaling_group_name" = 'VALUE';

Description

Gets information about the traffic sources for the specified Auto Scaling group.

You can optionally provide a traffic source type. If you provide a traffic source type, then the results only include that traffic source type.

If you do not provide a traffic source type, then the results include all the traffic sources for the specified Auto Scaling group.

Table Definition

Column NameColumn Data Type
auto_scaling_group_name Required Input Column

The name of the Auto Scaling group.

VARCHAR
max_records Input Column

The maximum number of items to return with this call. The maximum value is 50.

BIGINT
next_token Input Column

This string indicates that the response contains more items than can be returned in a single response. To receive additional items, specify this string for the NextToken value when requesting the next set of items. This value is null when there are no more items to return.

VARCHAR
traffic_source_type Input Column

The traffic source type that you want to describe.

The following lists the valid values:

  • elb if the traffic source is a Classic Load Balancer.

  • elbv2 if the traffic source is a Application Load Balancer, Gateway Load Balancer, or Network Load Balancer.

  • vpc-lattice if the traffic source is VPC Lattice.

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
traffic_sources

Information about the traffic sources.

STRUCT(
    "traffic_source" VARCHAR,
    "state" VARCHAR,
    "identifier" VARCHAR,
    "type" VARCHAR
)[]
Show child fields
traffic_sources[]
Show child fields
traffic_sources[].identifier

The unique identifier of the traffic source.

traffic_sources[].state

Describes the current state of a traffic source.

The state values are as follows:

  • Adding - The Auto Scaling instances are being registered with the load balancer or target group.

  • Added - All Auto Scaling instances are registered with the load balancer or target group.

  • InService - For an Elastic Load Balancing load balancer or target group, at least one Auto Scaling instance passed an ELB health check. For VPC Lattice, at least one Auto Scaling instance passed an VPC_LATTICE health check.

  • Removing - The Auto Scaling instances are being deregistered from the load balancer or target group. If connection draining (deregistration delay) is enabled, Elastic Load Balancing or VPC Lattice waits for in-flight requests to complete before deregistering the instances.

  • Removed - All Auto Scaling instances are deregistered from the load balancer or target group.

traffic_sources[].traffic_source

This is replaced by Identifier.

traffic_sources[].type

Provides additional context for the value of Identifier.

The following lists the valid values:

  • elb if Identifier is the name of a Classic Load Balancer.

  • elbv2 if Identifier is the ARN of an Application Load Balancer, Gateway Load Balancer, or Network Load Balancer target group.

  • vpc-lattice if Identifier is the ARN of a VPC Lattice target group.

Required if the identifier is the name of a Classic Load Balancer.