Need help finding specific SKU for AWS instances using CloudQuery

Hello!

Using the AWS plugin, I am trying to find the specific SKU my instances are defined as. I want to use that data for some FinOps. :slightly_smiling_face:

Hi @funky-labrador :wave:

Have you seen the AWS Pricing source plugin? AWS Pricing Source Plugin Documentation

It has a table called awspricing_service_products that lists SKUs. I believe you should be able to use the attributes there to correlate with your instances from the AWS source plugin.

Hello, that’s what I am doing. The correlation is quite tricky. I was hoping to get an SKU in the aws_ec2_instances, so it would make my life easier :slightly_smiling_face:

Ah, I see… Yeah, sorry that is not available, and we’re unlikely to add it to that table directly because it’s not returned by the underlying AWS APIs either. But feel free to raise an issue and describe the problem and solution you’d like, and we can discuss some options: GitHub Issue

Do you have a query anywhere that can cross-reference?
If not, I am building it anyway, it’s just to save time. :smile:

I’m afraid I don’t have anything. Would love to see what you come up with though, I’m sure it will be useful to others as well!