Why doesn't aws_ec2_instance_type table support the account_id (and region) column? about steampipe-plugin-aws

[graza-io]

In addition to the above, would be also useful to be able to filter by instance family m5a, m5, t3, etc - This would drastically increase performance.

[ParthaI]

@e-gineer / @graza-io, I've submitted a PR to address this issue. Here are the changes implemented:

• We can now obtain results for each region.
• It's possible to filter by instance type as demonstrated (select instance_type, region from aws_ec2_instance_type where instance_type = 'r6g.large').
• The API does not support filtering by instance family. While specific instances like m6g.metal can be filtered, broader family filters like m6g are not supported. Reference: AWS API Documentation

---

Also - do instance types vary by region? If so, should this table be querying by region?

Yes, it varies from region to region.

> select count(*) from aws_ec2_instance_type where region = 'us-east-1'
+-------+
| count |
+-------+
| 776   |
+-------+

> select count(*) from aws_ec2_instance_type where region = 'ap-south-1'
+-------+
| count |
+-------+
| 518   |
+-------+

Please let me know if I have missed any other implementations.

Thank you!