aws.elb.describe_load_balancer_attributes

Example SQL Queries

SELECT * FROM
aws.elb.describe_load_balancer_attributes
WHERE
"load_balancer_name" = 'VALUE';

Description

Describes the attributes for the specified load balancer.

• View All Elastic Load Balancing Tables
• Boto3 Reference

Table Definition

Column Name	Column Data Type
load_balancer_name Required Input Column The name of the load balancer.	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.
load_balancer_attributes Information about the load balancer attributes.	STRUCT( "cross_zone_load_balancing" STRUCT( "enabled" BOOLEAN ), "access_log" STRUCT( "enabled" BOOLEAN, "s3_bucket_name" VARCHAR, "emit_interval" BIGINT, "s3_bucket_prefix" VARCHAR ), "connection_draining" STRUCT( "enabled" BOOLEAN, "timeout" BIGINT ), "connection_settings" STRUCT( "idle_timeout" BIGINT ), "additional_attributes" STRUCT( "key" VARCHAR, "value" VARCHAR )[] )
Show child fields load_balancer_attributes.access_log If enabled, the load balancer captures detailed information of all requests and delivers the information to the Amazon S3 bucket that you specify. For more information, see Enable Access Logs in the Classic Load Balancers Guide. Show child fields load_balancer_attributes.access_log.emit_interval The interval for publishing the access logs. You can specify an interval of either 5 minutes or 60 minutes. Default: 60 minutes load_balancer_attributes.access_log.enabled Specifies whether access logs are enabled for the load balancer. load_balancer_attributes.access_log.s3_bucket_name The name of the Amazon S3 bucket where the access logs are stored. load_balancer_attributes.access_log.s3_bucket_prefix The logical hierarchy you created for your Amazon S3 bucket, for example my-bucket-prefix/prod. If the prefix is not provided, the log is placed at the root level of the bucket. load_balancer_attributes.additional_attributes[] Show child fields load_balancer_attributes.additional_attributes[].key The name of the attribute. The following attribute is supported. elb.http.desyncmitigationmode - Determines how the load balancer handles requests that might pose a security risk to your application. The possible values are monitor, defensive, and strictest. The default is defensive. load_balancer_attributes.additional_attributes[].value This value of the attribute. load_balancer_attributes.connection_draining If enabled, the load balancer allows existing requests to complete before the load balancer shifts traffic away from a deregistered or unhealthy instance. For more information, see Configure Connection Draining in the Classic Load Balancers Guide. Show child fields load_balancer_attributes.connection_draining.enabled Specifies whether connection draining is enabled for the load balancer. load_balancer_attributes.connection_draining.timeout The maximum time, in seconds, to keep the existing connections open before deregistering the instances. load_balancer_attributes.connection_settings If enabled, the load balancer allows the connections to remain idle (no data is sent over the connection) for the specified duration. By default, Elastic Load Balancing maintains a 60-second idle connection timeout for both front-end and back-end connections of your load balancer. For more information, see Configure Idle Connection Timeout in the Classic Load Balancers Guide. Show child fields load_balancer_attributes.connection_settings.idle_timeout The time, in seconds, that the connection is allowed to be idle (no data has been sent over the connection) before it is closed by the load balancer. load_balancer_attributes.cross_zone_load_balancing If enabled, the load balancer routes the request traffic evenly across all instances regardless of the Availability Zones. For more information, see Configure Cross-Zone Load Balancing in the Classic Load Balancers Guide. Show child fields load_balancer_attributes.cross_zone_load_balancing.enabled Specifies whether cross-zone load balancing is enabled for the load balancer.

Note

Tables may require input columns to have values specified before the table can return it’s rows. The values for input parameters are set in the where clause of the query typically using = or IN.