导入云资源清单

1. 使用文件编辑器打开下载的资源清单CSV文件，在表头行搜索“PrivatePort(A network port,)”。
2. 将该表头名中的英文逗号删除，然后保存文件。正确的表头名应该为“PrivatePort(A network port)”。

1. 使用文件编辑器打开下载的资源清单CSV文件，
2. 在表头行的末尾，添加一个英文逗号，然后保存文件。

   例如，原始表头为：

   ID,Name,Quantity

   修改后的表头应该是：

   ID,Name,Quantity,

SELECT
  resource_type,
  resource_id,
  resource_name,
  region_id,
  zone_id,
  create_time,
  resource_group_id,
  tags,
  ip_addresses,
  vpc_id,
  v_switch_id,
  properties
FROM
  resources
ORDER BY
  region_id,
  resource_type,
  resource_id

SELECT
  resource_type,
  resource_id,
  resource_name,
  region_id,
  zone_id, 
  create_time, 
  resource_group_id,
  ip_addresses,
  tags,
  vpc_id,
  v_switch_id,
  properties ->> 'InstanceId' as instance_id,
  properties ->> 'CreditSpecification' as credit_specification,
  properties ->> 'OSName' as os_name,
  properties ->> 'HostName' as host_name,
  properties ->> 'Status' as status,
  properties ->> 'Description' as description,
  properties ->> 'InstanceType' as instance_type,
  properties ->> 'InstanceTypeFamily' as instance_type_family,
  properties ->> 'ImageId' as image_id,
  properties ->> 'Cpu' as cpu,
  properties ->> 'Memory' as memory,  
  properties -> 'PublicIpAddress' ->> 'IpAddress' as public_ip_address,
  properties -> 'VpcAttributes' -> 'PrivateIpAddress' ->> 'IpAddress' as private_ip_address,
  properties -> 'EipAddress' ->> 'IpAddress' as eip_address_ip,
  properties -> 'EipAddress' ->> 'Bandwidth' as bandwidth, 
  properties ->> 'ExpiredTime' as expired_time,
  properties -> 'SecurityGroupIds' ->> 'SecurityGroupId' as security_group_id,
  properties ->> 'Size' as disk_size,
  properties ->> 'DeleteWithInstance' as delete_with_instance,
  properties ->> 'DeleteAutoSnapshot' as delete_auto_snapshot,
  properties ->> 'Type' as disk_type,
  properties ->> 'Encrypted' as disk_encrypted,
  properties ->> 'DetachedTime' as disk_detached_time,
  properties ->> 'AutoSnapshotPolicyId' as auto_snapshot_policy_id,
  properties ->> 'IOPS' as iops,
  properties ->> 'IOPSRead' as iops_read,
  properties ->> 'IOPSWrite' as iops_write,
  properties ->> 'PerformanceLevel' as performance_level,
  properties ->> 'SourceSnapshotId' as disk_source_snapshot_id
FROM
  resources 
WHERE
  resource_type = 'ACS::ECS::Instance' OR resource_type = 'ACS::ECS::Disk'

SELECT
  resource_type,
  resource_id,
  resource_name,
  region_id,
  zone_id, 
  create_time, 
  resource_group_id,
  ip_addresses,
  tags,
  vpc_id,
  v_switch_id,
  properties ->> 'InstanceId' as instance_id,
  properties ->> 'DBInstanceDescription' as description,
  properties ->> 'DBInstanceType' as db_instance_type,
  properties ->> 'DBInstanceClass' as db_instance_class,
  properties ->> 'DBInstanceClassType' as db_instance_class_type,
  properties ->> 'Category' as category,
  properties ->> 'DBInstanceCPU' as db_instance_cpu,
  properties ->> 'DBInstanceMemory' as db_instance_memory,
  properties ->> 'MaxIOPS' as max_iops,
  properties ->> 'DBInstanceStorage' as db_instance_storage,
  properties ->> 'Engine' as engine,
  properties ->> 'EngineVersion' as engine_version,
  properties ->> 'InstanceNetworkType' as instance_network_type,
  properties ->> 'PayType' as pay_type,
  properties ->> 'ExpireTime' as expire_time,
  properties ->> 'MaxConnections' as max_connections
FROM
  resources
WHERE
  resource_type = 'ACS::RDS::DBInstance'