list_aws_vpc

Column	Type
vpc_name	BLOB
account	BLOB
owner	BLOB
region	BLOB
state	BLOB
cidr_block	BLOB
dhcp_options_id	BLOB
is_default	BLOB
partition	BLOB

SQL DDL

CREATE VIEW list_aws_vpc AS
SELECT
vpc.title as vpc_name,
account.title as account,
account.title as owner,
vpc.region,
vpc.state,
vpc.cidr_block,
vpc.dhcp_options_id,
vpc.is_default,
vpc.partition
FROM
  ur_transform_aws_vpc vpc
LEFT JOIN ur_transform_aws_account_info account ON vpc.account_id = account.account_id