Create a table for AWS Cost Optimization Hub recommendations

[2020python]

Is your feature request related to a problem? Please describe.
AWS has the Cost Optimization Hub (COH) under Billing and Cost Management to provide recommendations of where to save money. Example recommendations are around moving to a different EBS volume type, decreasing memory for a Lambda, or purchasing a compute saving plan. This request is to ask for COH recommendations to be included in a Steampipe table. This could be from the payor account of an AWS Organization or from all member accounts.

An example CLI call is with "aws cost-optimization-hub list-recommendations"

Describe the solution you'd like
One additional table, with a row for each account and a JSON structure of each finding and its cost savings potentials.

Describe alternatives you've considered
Our alternative to Pipes is to use a Lambda with boto3 calls to the payor account, or to all accounts, to collect the recommendations and display in a Quicksight report.

Additional context
Add any other context or screenshots about the feature request here.

[misraved]

Hello @2020python, welcome to Steampipe 👍 !!

Thanks for raising the table issue with good details on its usage.

Have you tried out https://hub.powerpipe.io/mods/turbot/aws_thrifty? It provides a good set of controls and benchmarks for cost and resource management.

[2020python]

Hello @2020python, welcome to Steampipe 👍 !!

Thanks for raising the table issue with good details on its usage.

Have you tried out https://hub.powerpipe.io/mods/turbot/aws_thrifty? It provides a good set of controls and benchmarks for cost and resource management.

Hi @misraved, yes we have AWS Thrifty installed and it has a lot of great cost related content. However, there are items in the AWS Cost Optimization Hub that I can't find directly in Thrifty, such as for one account they use dozens of EBS volumes for EKS (Kubernetes), and one set of recommendations is to move from the more expensive io1 to the io2 EOT type, saving about $1000 per volume. This detail is not available in Thrifty. This is just one example. So this request is asking for COH output specifically so we can get the complete list of recommendations, preferring Pipes over writing our own Lambda boto3 script outside of Pipes.

[ParthaI]

Hello @2020python,

We have raised a PR to address the issue mentioned above. However, we couldn't test it in our environment as we currently don't have any data available. I enabled the Cost Optimization Hub today, but please note that it requires up to 24 hours for the initial data population. Afterward, the data will be refreshed daily. You can find more details in this AWS doc.

In the meantime, it would be immensely helpful if you could try testing it on the PR branch (issue-2350) and share your observations with us.

Thank you for your time and support!