list_aws_ec2_application_load_balancer

Column Type
name BLOB
account BLOB
owner BLOB
vpc BLOB
region BLOB
created_time BLOB
dns_name BLOB
ip_address_type BLOB
load_balancer_attributes BLOB
scheme BLOB
security_groups BLOB
type BLOB

SQL DDL

CREATE VIEW list_aws_ec2_application_load_balancer AS
SELECT
lb.name,
account.title as account,
account.title as owner,
vpc.title as vpc,
lb.region,
lb.created_time,
lb.dns_name,
lb.ip_address_type,
lb.load_balancer_attributes,
lb.scheme,
lb.security_groups,
lb.type
FROM
  ur_transform_aws_ec2_application_load_balancer lb
INNER JOIN ur_transform_aws_account_info account ON lb.account_id = account.account_id
INNER JOIN ur_transform_aws_vpc vpc ON lb.vpc_id=vpc.vpc_id
;