steampipe-plugin-aws
steampipe-plugin-aws copied to clipboard
Updated tables as per EC2 package version updated
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.
>