Skip to main content
Version: 0.0.25

Table: load_balancer

Table to manage AWS Load Balancers. Elastic Load Balancing automatically distributes your incoming traffic across multiple targets, such as EC2 instances, containers, and IP addresses, in one or more Availability Zones.

A load balancer serves as the single point of contact for clients. The load balancer distributes incoming application traffic across multiple targets, such as EC2 instances, in multiple Availability Zones. This increases the availability of your application.

You add one or more listeners to your load balancer.


INSERT INTO load_balancer (load_balancer_name, scheme, vpc, load_balancer_type, ip_address_type)
VALUES ('load_balancer', 'internet-facing', null, 'application', 'ipv4');

SELECT * FROM load_balancer WHERE load_balancer_name = 'load_balancer';

DELETE FROM load_balancer WHERE load_balancer_name = 'load_balancer';



Optional attributes: load_balancer_attribute[]

Optional availability_zones: string[]

Reference to the associated availability zones for the load balancer


Optional canonical_hosted_zone_id: string

Hosted zone to route traffic to the load balancer


Optional created_time: date

Creation date

Optional customer_owned_ipv4_pool: string

Reference to an specific pool of address for ipv4


Optional dns_name: string

Custom domain name to associate with your load balancer.


ip_address_type: ip_address_type

Whether to expose ipv4 or dual stack

Optional load_balancer_arn: string

AWS ARN that identifies the load balancer

load_balancer_name: string

Name to identify the load balancer

load_balancer_type: load_balancer_type

Type of load balancer

region: string

Region for the load balancer

scheme: load_balancer_scheme

Schema for the load balancer

Optional security_groups: security_group[]

Reference to the associated security groups for the load balancer


Optional state: load_balancer_state

Current status of the load balancer

Optional subnets: string[]

Reference to the associated subnets for a load balancer


Optional vpc: vpc

Reference to the VPC associated with the load balancer