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
INNER JOIN ur_transform_aws_account_info account ON vpc.account_id = account.account_id