list_aws_ec2_instance

Column	Type
instance_id	BLOB
account_id	BLOB
title	BLOB
architecture	BLOB
platform_details	BLOB
root_device_name	BLOB
state	BLOB
instance_type	BLOB
cpu_options_core_count	BLOB
az	BLOB
launch_time	BLOB
network_interface_id	BLOB
private_ip_address	BLOB
public_ip_address	BLOB
subnet_id	BLOB
vpc_id	BLOB
mac_address	BLOB
status	BLOB
vpc_name	BLOB
vpc_state	BLOB

SQL DDL

CREATE VIEW list_aws_ec2_instance AS
SELECT
  ec2.instance_id,
  ec2.account_id,
  ec2.title,
  ec2.architecture,
  ec2.platform_details,
  ec2.root_device_name,
  ec2.state,
  ec2.instance_type,
  ec2.cpu_options_core_count,
  ec2.az,
  ec2.launch_time,
  ec2.network_interface_id,
  ec2.private_ip_address,
  ec2.public_ip_address,
  ec2.subnet_id,
  ec2.vpc_id,
  ec2.mac_address,
  ec2.status,
  vpc.title as vpc_name,
  vpc.state as vpc_state
FROM
  ur_transform_ec2_instance AS ec2
LEFT JOIN ur_transform_aws_vpc vpc ON ec2.vpc_id=vpc.vpc_id