steampipe plugin install awssteampipe plugin install aws

Table: aws_ec2_gateway_load_balancer

Gateway Load Balancer makes it easy to deploy, scale, and run third-party virtual networking appliances. Providing load balancing and auto scaling for fleets of third-party appliances, Gateway Load Balancer is transparent to the source and destination of traffic. This capability makes it well suited for working with third-party appliances for security, network analytics, and other use cases.

Examples

Basic gateway load balancer info

select
  name,
  arn,
  type,
  state_code,
  vpc_id,
  availability_zones
from
  aws_ec2_gateway_load_balancer;

Availability zone information of all the gateway load balancers

select
  name,
  az ->> 'LoadBalancerAddresses' as load_balancer_addresses,
  az ->> 'OutpostId' as outpost_id,
  az ->> 'SubnetId' as subnet_id,
  az ->> 'ZoneName' as zone_name
from
  aws_ec2_gateway_load_balancer,
  jsonb_array_elements(availability_zones) as az;

List of gateway load balancers whose availability zone count is less than 2

select
  name,
  count(az ->> 'ZoneName') as zone_count
from
  aws_ec2_gateway_load_balancer,
  jsonb_array_elements(availability_zones) as az
group by
  name
having
  count(az ->> 'ZoneName') < 2;

List of gateway load balancers whose deletion protection is not enabled

select
  name,
  lb ->> 'Key' as deletion_protection_key,
  lb ->> 'Value' as deletion_protection_value
from
  aws_ec2_gateway_load_balancer,
  jsonb_array_elements(load_balancer_attributes) as lb
where
  lb ->> 'Key' = 'deletion_protection.enabled'
  and lb ->> 'Value' = 'false';

List of gateway load balancers whose load balancing cross zone is enabled

select
  name,
  lb ->> 'Key' as load_balancing_cross_zone_key,
  lb ->> 'Value' as load_balancing_cross_zone_value
from
  aws_ec2_gateway_load_balancer,
  jsonb_array_elements(load_balancer_attributes) as lb
where
  lb ->> 'Key' = 'load_balancing.cross_zone.enabled'
  and lb ->> 'Value' = 'true';

Security group attached to the gateway load balancers

select
  name,
  jsonb_array_elements_text(security_groups) as attached_security_group
from
  aws_ec2_gateway_load_balancer;

List of gateway load balancer with state other than active

select
  name,
  state_code
from
  aws_ec2_gateway_load_balancer
where
  state_code <> 'active';

Query examples

Control examples

.inspect aws_ec2_gateway_load_balancer

AWS EC2 Gateway Load Balancer

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
arn	text	The Amazon Resource Name (ARN) of the load balancer.
availability_zones	jsonb	The subnets for the gateway load balancer.
canonical_hosted_zone_id	text	The ID of the Amazon Route 53 hosted zone associated with the gateway load balancer.
created_time	timestamp with time zone	The date and time the load balancer was created.
customer_owned_ipv4_pool	text	The ID of the customer-owned address pool.
dns_name	text	The public DNS name of the gateway load balancer.
ip_address_type	text	The type of IP addresses used by the subnets for your load balancer.
load_balancer_attributes	jsonb	Attributes deletion protection and cross_zone of gateway load balancer.
name	text	The name of the load balancer.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
scheme	text	The load balancing scheme of gateway load balancer.
security_groups	jsonb	The IDs of the security groups for the gateway load balancer.
state_code	text	The state of the load balancer.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags attached to the load balancer.
title	text	Title of the resource.
type	text	The type of load balancer.
vpc_id	text	The ID of the VPC for the gateway load balancer.

turbot/aws