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
;