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