Cost optimization recommendations (from Cost Optimization Hub)
The cost optimization recommendations table contains your cost optimization
recommendations from Cost Optimization Hub. Cost Optimization Hub recommendations are
consolidated from Amazon Compute Optimizer and consist of over 15 types of optimizations,
such as resource rightsizing, idle resource deletion, Savings Plans, and Reserved
Instances. For more detailed information, see Cost Optimization Hub
The SQL table name for cost optimization recommendations is
COST_OPTIMIZATION_RECOMMENDATIONS.
Table configurations
Table configurations are user-controlled properties that a user can set to change the data or schema of a table before it's queried in Data Exports. The table configurations are saved as a JSON statement and are either specified through user input in the Amazon SDK/CLI or user selections in the console.
Cost optimization recommendations has the following table configurations:
| Configuration name | Description | Valid values |
|---|---|---|
| INCLUDE_ALL_RECOMMENDATIONS |
When set to "FALSE", only the highest savings value recommendation is kept in the table from any set of recommendations that are incompatible with one another. For example, only "Terminate instance" is kept from a recommendation to terminate an instance and a recommendation to rightsize the same instance. When set to "TRUE", all recommendations are kept in the table. This is also known as Group related recommendations in the Cost Optimization Hub console. For more information, see Grouping related recommendations in the Amazon Cost Management User Guide. |
TRUE, FALSE |
| FILTER |
This allows you to filter recommendations based on different recommendation attributes. Filters are applied to the table before the savings deduplication algorithm is applied. You can filter using the same parameters as in the Cost Optimization Hub console. For more information, see Prioritizing your cost optimization opportunities in the Amazon Cost Management User Guide. Filter statements are provided for this configuration using
the same JSON structure that is used in the |
Any JSON string that is valid for the Cost Optimization Hub
list-recommendations API. |
Service-linked role
A service-linked role for Data Exports is required to create an export of the cost optimization recommendations table. For information on how to create the service-linked role, see Service-linked roles for Data Exports in the Amazon Cost Management User Guide.
Amazon Organizations support
Cost Optimization Hub integrates with Amazon Organizations to control whether a
management account can see member account recommendations in Cost Optimization Hub.
For more information, see Getting started with Cost Optimization Hub
The cost optimization recommendations table for a given Amazon account inherits the same Amazon Organizations settings you configured for Cost Optimization Hub. This means the content of the cost optimization recommendations table matches the recommendations that appear in Cost Optimization Hub for each Amazon account.