| Column Name | Column Data Type |
|---|
load_balancer_arns Input Column
The Amazon Resource Names (ARN) of the load balancers. You can specify up to 20 load balancers in a single call. | VARCHAR[] |
Show child fields- load_balancer_arns[]
|
names Input Column
The names of the load balancers. | VARCHAR[] |
Show child fields- 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 subnets for the load balancer. | STRUCT(
"zone_name" VARCHAR,
"subnet_id" VARCHAR,
"outpost_id" VARCHAR,
"load_balancer_addresses" STRUCT(
"ip_address" VARCHAR,
"allocation_id" VARCHAR,
"private_i_pv4_address" VARCHAR,
"i_pv6_address" VARCHAR
)[]
)[] |
Show child fields- availability_zones[]
Show child fields- availability_zones[].load_balancer_addresses[]
Show child fields- availability_zones[].load_balancer_addresses[].allocation_id
[Network Load Balancers] The allocation ID of the Elastic IP address for an internal-facing load balancer. - availability_zones[].load_balancer_addresses[].i_pv6_address
[Network Load Balancers] The IPv6 address. - availability_zones[].load_balancer_addresses[].ip_address
The static IP address. - availability_zones[].load_balancer_addresses[].private_i_pv4_address
[Network Load Balancers] The private IPv4 address for an internal load balancer.
- availability_zones[].outpost_id
[Application Load Balancers on Outposts] The ID of the Outpost. - availability_zones[].subnet_id
The ID of the subnet. You can specify one subnet per Availability Zone. - availability_zones[].zone_name
The name of the Availability Zone.
|
canonical_hosted_zone_id
The ID of the Amazon Route 53 hosted zone associated with the load balancer. | VARCHAR |
created_time
The date and time the load balancer was created. | TIMESTAMP_S |
customer_owned_ipv4_pool
[Application Load Balancers on Outposts] The ID of the customer-owned address pool. | VARCHAR |
dns_name
The public DNS name of the load balancer. | VARCHAR |
enforce_security_group_inbound_rules_on_private_link_traffic
Indicates whether to evaluate inbound security group rules for traffic sent to a Network Load Balancer through Amazon Web Services PrivateLink. | VARCHAR |
ip_address_type
[Application Load Balancers] The type of IP addresses used for public or private connections by the subnets attached to your load balancer. The possible values are ipv4 (for only IPv4 addresses), dualstack (for IPv4 and IPv6 addresses), and dualstack-without-public-ipv4 (for IPv6 only public addresses, with private IPv4 and IPv6 addresses). [Network Load Balancers and Gateway Load Balancers] The type of IP addresses used for public or private connections by the subnets attached to your load balancer. The possible values are ipv4 (for only IPv4 addresses) and dualstack (for IPv4 and IPv6 addresses). | VARCHAR |
load_balancer_arn
The Amazon Resource Name (ARN) of the load balancer. | VARCHAR |
load_balancer_name
The name of the load balancer. | VARCHAR |
scheme
The nodes of an Internet-facing load balancer have public IP addresses. The DNS name of an Internet-facing load balancer is publicly resolvable to the public IP addresses of the nodes. Therefore, Internet-facing load balancers can route requests from clients over the internet. The nodes of an internal load balancer have only private IP addresses. The DNS name of an internal load balancer is publicly resolvable to the private IP addresses of the nodes. Therefore, internal load balancers can route requests only from clients with access to the VPC for the load balancer. | VARCHAR |
security_groups
The IDs of the security groups for the load balancer. | VARCHAR[] |
Show child fields- security_groups[]
|
state
The state of the load balancer. | STRUCT(
"code" VARCHAR,
"reason" VARCHAR
) |
Show child fields- state.code
The state code. The initial state of the load balancer is provisioning. After the load balancer is fully set up and ready to route traffic, its state is active. If load balancer is routing traffic but does not have the resources it needs to scale, its state isactive_impaired. If the load balancer could not be set up, its state is failed. - state.reason
A description of the state.
|
type
The type of load balancer. | VARCHAR |
vpc_id
The ID of the VPC for the load balancer. | VARCHAR |