| Column Name | Column Data Type |
|---|
load_balancer_names Input Column
The names of the load balancers. | VARCHAR[] |
Show child fields- load_balancer_names[]
|
_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.
|
availability_zones
The Availability Zones for the load balancer. | VARCHAR[] |
Show child fields- availability_zones[]
|
backend_server_descriptions
Information about your EC2 instances. | STRUCT(
"instance_port" BIGINT,
"policy_names" VARCHAR[]
)[] |
Show child fields- backend_server_descriptions[]
Show child fields- backend_server_descriptions[].instance_port
The port on which the EC2 instance is listening. - backend_server_descriptions[].policy_names[]
|
canonical_hosted_zone_name
The DNS name of the load balancer. For more information, see Configure a Custom Domain Name in the Classic Load Balancers Guide. | VARCHAR |
canonical_hosted_zone_name_id
The ID of the Amazon Route 53 hosted zone for the load balancer. | VARCHAR |
created_time
The date and time the load balancer was created. | TIMESTAMP_S |
dns_name
The DNS name of the load balancer. | VARCHAR |
health_check
Information about the health checks conducted on the load balancer. | STRUCT(
"target" VARCHAR,
"interval" BIGINT,
"timeout" BIGINT,
"unhealthy_threshold" BIGINT,
"healthy_threshold" BIGINT
) |
Show child fields- health_check.healthy_threshold
The number of consecutive health checks successes required before moving the instance to the Healthy state. - health_check.interval
The approximate interval, in seconds, between health checks of an individual instance. - health_check.target
The instance being checked. The protocol is either TCP, HTTP, HTTPS, or SSL. The range of valid ports is one (1) through 65535. TCP is the default, specified as a TCP: port pair, for example "TCP:5000". In this case, a health check simply attempts to open a TCP connection to the instance on the specified port. Failure to connect within the configured timeout is considered unhealthy. SSL is also specified as SSL: port pair, for example, SSL:5000. For HTTP/HTTPS, you must include a ping path in the string. HTTP is specified as a HTTP:port;/;PathToPing; grouping, for example "HTTP:80/weather/us/wa/seattle". In this case, a HTTP GET request is issued to the instance on the given port and path. Any answer other than "200 OK" within the timeout period is considered unhealthy. The total length of the HTTP ping target must be 1024 16-bit Unicode characters or less. - health_check.timeout
The amount of time, in seconds, during which no response means a failed health check. This value must be less than the Interval value. - health_check.unhealthy_threshold
The number of consecutive health check failures required before moving the instance to the Unhealthy state.
|
instances
The IDs of the instances for the load balancer. | STRUCT(
"instance_id" VARCHAR
)[] |
Show child fields- instances[]
Show child fields- instances[].instance_id
The instance ID.
|
listener_descriptions
The listeners for the load balancer. | STRUCT(
"listener" STRUCT(
"protocol" VARCHAR,
"load_balancer_port" BIGINT,
"instance_protocol" VARCHAR,
"instance_port" BIGINT,
"ssl_certificate_id" VARCHAR
),
"policy_names" VARCHAR[]
)[] |
Show child fields- listener_descriptions[]
Show child fields- listener_descriptions[].listener
The listener. Show child fields- listener_descriptions[].listener.instance_port
The port on which the instance is listening. - listener_descriptions[].listener.instance_protocol
The protocol to use for routing traffic to instances: HTTP, HTTPS, TCP, or SSL. If the front-end protocol is TCP or SSL, the back-end protocol must be TCP or SSL. If the front-end protocol is HTTP or HTTPS, the back-end protocol must be HTTP or HTTPS. If there is another listener with the same InstancePort whose InstanceProtocol is secure, (HTTPS or SSL), the listener's InstanceProtocol must also be secure. If there is another listener with the same InstancePort whose InstanceProtocol is HTTP or TCP, the listener's InstanceProtocol must be HTTP or TCP. - listener_descriptions[].listener.load_balancer_port
The port on which the load balancer is listening. On EC2-VPC, you can specify any port from the range 1-65535. On EC2-Classic, you can specify any port from the following list: 25, 80, 443, 465, 587, 1024-65535. - listener_descriptions[].listener.protocol
The load balancer transport protocol to use for routing: HTTP, HTTPS, TCP, or SSL. - listener_descriptions[].listener.ssl_certificate_id
The Amazon Resource Name (ARN) of the server certificate.
- listener_descriptions[].policy_names[]
|
load_balancer_name
The name of the load balancer. | VARCHAR |
policies
The policies defined for the load balancer. | STRUCT(
"app_cookie_stickiness_policies" STRUCT(
"policy_name" VARCHAR,
"cookie_name" VARCHAR
)[],
"lb_cookie_stickiness_policies" STRUCT(
"policy_name" VARCHAR,
"cookie_expiration_period" BIGINT
)[],
"other_policies" VARCHAR[]
) |
Show child fields- policies.app_cookie_stickiness_policies[]
Show child fields- policies.app_cookie_stickiness_policies[].cookie_name
The name of the application cookie used for stickiness. - policies.app_cookie_stickiness_policies[].policy_name
The mnemonic name for the policy being created. The name must be unique within a set of policies for this load balancer.
- policies.lb_cookie_stickiness_policies[]
Show child fields- policies.lb_cookie_stickiness_policies[].cookie_expiration_period
The time period, in seconds, after which the cookie should be considered stale. If this parameter is not specified, the stickiness session lasts for the duration of the browser session. - policies.lb_cookie_stickiness_policies[].policy_name
The name of the policy. This name must be unique within the set of policies for this load balancer.
- policies.other_policies[]
|
scheme
The type of load balancer. Valid only for load balancers in a VPC. If Scheme is internet-facing, the load balancer has a public DNS name that resolves to a public IP address. If Scheme is internal, the load balancer has a public DNS name that resolves to a private IP address. | VARCHAR |
security_groups
The security groups for the load balancer. Valid only for load balancers in a VPC. | VARCHAR[] |
Show child fields- security_groups[]
|
source_security_group
The security group for the load balancer, which you can use as part of your inbound rules for your registered instances. To only allow traffic from load balancers, add a security group rule that specifies this source security group as the inbound source. | STRUCT(
"owner_alias" VARCHAR,
"group_name" VARCHAR
) |
Show child fields- source_security_group.group_name
The name of the security group. - source_security_group.owner_alias
The owner of the security group.
|
subnets
The IDs of the subnets for the load balancer. | VARCHAR[] |
Show child fields- subnets[]
|
vpc_id
The ID of the VPC for the load balancer. | VARCHAR |