Table: alicloud_slb_load_balancer

Server Load Balancer (SLB) distributes network traffic across groups of backend servers to improve the service capability and application availability. It Includes Layer 4 Network Load Balancer (NLB), Layer 7 Application Load Balancer (ALB), and Classic Load Balancer (CLB). It is the Official Cloud-Native Gateway of Alibaba Cloud.

Examples

Basic info

select
  load_balancer_name,
  load_balancer_id,
  load_balancer_status,
  address,
  address_type,
  vpc_id,
  network_type
from
  alicloud_slb_load_balancer;

Get VPC details associated with SLB load balancers

select
  s.load_balancer_name,
  s.load_balancer_id,
  s.vpc_id,
  v.is_default,
  v.cidr_block
from
  alicloud_slb_load_balancer as s,
  alicloud_vpc as v;

List SLB load balancers that have deletion protection enabled

select
  load_balancer_name,
  load_balancer_id,
  load_balancer_status,
  delete_protection
from
  alicloud_slb_load_balancer
where
  delete_protection = 'on';

List SLB load balancers created in the last 30 days

select
  load_balancer_name,
  load_balancer_id,
  load_balancer_status
from
  alicloud_slb_load_balancer
where
  create_time >= now() - interval '30' day;

.inspect alicloud_slb_load_balancer

Alicloud Server Load Balancer

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The Alicloud Account ID in which the resource is located.
address	inet	The service IP address of the SLB instance.
address_ip_version	text	The IP version. Valid values: ipv4 and ipv6.
address_type	text	The network type of the SLB instance. Valid values: internet\|intranet.
bandwidth	bigint	The maximum bandwidth of the listener. Unit: Mbit/s.
create_time	timestamp with time zone	The time when the SLB instance was created.
create_time_stamp	timestamp with time zone	The timestamp when the instance was created.
delete_protection	text	Indicates whether deletion protection is enabled for the SLB instance.
internet_charge_type	text	The metering method of Internet data transfer. Valid values: paybybandwidth\|paybytraffic.
internet_charge_type_alias	text	The alias for metering method of Internet data transfer.
load_balancer_id	text	The ID of the SLB instance.
load_balancer_name	text	The name of the SLB instance.
load_balancer_spec	text	The specification of the SLB instance.
load_balancer_status	text	The status of the SLB instance. Valid values: inactive\|active\|locked.
master_zone_id	text	The ID of the primary zone to which the SLB instance belongs.
modification_protection_reason	text	The reason why the configuration read-only mode is enabled.
modification_protection_status	text	Indicates whether the configuration read-only mode is enabled for the SLB instance.
network_type	text	The network type of the internal-facing SLB instance. Valid values: vpc\|classic.
pay_type	text	The billing method of the SLB instance. Valid values: PayOnDemand.
region	text	The Alicloud region in which the resource is located.
resource_group_id	text	The ID of the resource group.
slave_zone_id	text	The ID of the secondary zone to which the SLB instance belongs.
tags	text	A map of tags for the resource.
tags_src	jsonb	A list of tags.
title	text	Title of the resource.
v_switch_id	text	The ID of the vSwitch to which the SLB instance belongs.
vpc_id	text	The ID of the virtual private cloud (VPC) to which the SLB instance belongs.

turbot/alicloud