steampipe-plugin-aws icon indicating copy to clipboard operation
steampipe-plugin-aws copied to clipboard

Updated tables as per EC2 package version updated

Open ParthaI opened this issue 4 months ago • 0 comments

Note: I have tested all the tables utilizing the EC2 package and found no breaking changes. The data from the current EC2 package in the main branch and the new EC2 package featured in this PR were compared, revealing identical results.

Integration test logs

Logs
N/A

Example query results

Results

> select * from aws_ec2_instance_availability limit 1
+---------------+-----------+---------------+-------------+------------------------------------------------------+---------------------------------------------------------------+
| instance_type | location  | location_type | title       | akas                                                 | _ctx                                                          |
+---------------+-----------+---------------+-------------+------------------------------------------------------+---------------------------------------------------------------+
| c7gd.medium   | us-east-1 | region        | c7gd.medium | ["arn:aws:ec2:us-east-1::instance-type/c7gd.medium"] | {"connection_name":"aws","steampipe":{"sdk_version":"5.8.0"}} |
+---------------+-----------+---------------+-------------+------------------------------------------------------+---------------------------------------------------------------+

Time: 3.8s. Rows fetched: 1. Hydrate calls: 1.
> select * from aws_ec2_instance_availability where location_type = 'region'limit 1
+---------------+------------+---------------+--------------+--------------------------------------------------------+---------------------------------------------------------------+
| instance_type | location   | location_type | title        | akas                                                   | _ctx                                                          |
+---------------+------------+---------------+--------------+--------------------------------------------------------+---------------------------------------------------------------+
| i4i.16xlarge  | ap-south-1 | region        | i4i.16xlarge | ["arn:aws:ec2:ap-south-1::instance-type/i4i.16xlarge"] | {"connection_name":"aws","steampipe":{"sdk_version":"5.8.0"}} |
+---------------+------------+---------------+--------------+--------------------------------------------------------+---------------------------------------------------------------+

Time: 304ms. Rows fetched: 1. Hydrate calls: 1.
> select * from aws_ec2_instance_availability where location_type = 'availability-zone' limit 1
+---------------+-------------+-------------------+--------------+---------------------------------------------------------+---------------------------------------------------------------+
| instance_type | location    | location_type     | title        | akas                                                    | _ctx                                                          |
+---------------+-------------+-------------------+--------------+---------------------------------------------------------+---------------------------------------------------------------+
| m5a.16xlarge  | ap-south-1a | availability-zone | m5a.16xlarge | ["arn:aws:ec2:ap-south-1a::instance-type/m5a.16xlarge"] | {"connection_name":"aws","steampipe":{"sdk_version":"5.8.0"}} |
+---------------+-------------+-------------------+--------------+---------------------------------------------------------+---------------------------------------------------------------+

Time: 252ms. Rows fetched: 1. Hydrate calls: 1.
> select * from aws_ec2_instance_availability where location_type = 'availability-zone-id' limit 1
+---------------+----------+----------------------+--------------+------------------------------------------------------+---------------------------------------------------------------+
| instance_type | location | location_type        | title        | akas                                                 | _ctx                                                          |
+---------------+----------+----------------------+--------------+------------------------------------------------------+---------------------------------------------------------------+
| m5a.16xlarge  | aps1-az1 | availability-zone-id | m5a.16xlarge | ["arn:aws:ec2:aps1-az1::instance-type/m5a.16xlarge"] | {"connection_name":"aws","steampipe":{"sdk_version":"5.8.0"}} |
+---------------+----------+----------------------+--------------+------------------------------------------------------+---------------------------------------------------------------+

Time: 247ms. Rows fetched: 1. Hydrate calls: 1.
> select * from aws_ec2_instance_availability where location_type = 'outpost' limit 1
+---------------+----------+---------------+-------+------+------+
| instance_type | location | location_type | title | akas | _ctx |
+---------------+----------+---------------+-------+------+------+
+---------------+----------+---------------+-------+------+------+

Time: 0.9s. Rows fetched: 0. Hydrate calls: 0.
> select * from aws_ec2_instance_type limit 1
+---------------+-------------------------+------------+---------------------------------+--------------------+---------------------------+--------------------+-----------------------+------------------------+-------------------+------------+--------------------------->
| instance_type | auto_recovery_supported | bare_metal | burstable_performance_supported | current_generation | dedicated_hosts_supported | free_tier_eligible | hibernation_supported | nitro_enclaves_support | nitro_tpm_support | hypervisor | instance_storage_supported>
+---------------+-------------------------+------------+---------------------------------+--------------------+---------------------------+--------------------+-----------------------+------------------------+-------------------+------------+--------------------------->
| r7a.2xlarge   | true                    | false      | false                           | true               | true                      | false              | true                  | unsupported            | supported         | nitro      | false                     >
+---------------+-------------------------+------------+---------------------------------+--------------------+---------------------------+--------------------+-----------------------+------------------------+-------------------+------------+--------------------------->

Time: 0.9s. Rows fetched: 1. Hydrate calls: 2.
> 

ParthaI avatar Feb 15 '24 09:02 ParthaI