# Cost optimization recommendations (from Cost Optimization Hub)
<a name="table-dictionary-cor"></a>

The cost optimization recommendations table contains your cost optimization recommendations from Cost Optimization Hub. Cost Optimization Hub recommendations are consolidated from AWS 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](https://docs.aws.amazon.com/cost-management/latest/userguide/cost-optimization-hub.html) in the *AWS Cost Management User Guide*.

The SQL table name for cost optimization recommendations is `COST_OPTIMIZATION_RECOMMENDATIONS`.

## Table configurations
<a name="cor-table-configurations"></a>

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 AWS SDK/CLI or user selections in the console.

Cost optimization recommendations has the following table configurations:


****  

| Configuration name | Description | Valid values | 
| --- | --- | --- | 
| INCLUDE\$1ALL\$1RECOMMENDATIONS |  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](https://docs.aws.amazon.com/cost-management/latest/userguide/coh-group-recommendations.html) in the *AWS 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](https://docs.aws.amazon.com/cost-management/latest/userguide/coh-prioritize-opportunities.html) in the *AWS Cost Management User Guide*. Filter statements are provided for this configuration using the same JSON structure that is used in the `filter` parameter in the Cost Optimization Hub `list-recommendations` API . It must be provided as a JSON string. For details, see the [`list-recommendations` structure](https://docs.aws.amazon.com/cli/latest/reference/cost-optimization-hub/list-recommendations.html#options).  | Any JSON string that is valid for the Cost Optimization Hub list-recommendations API. | 

## Service-linked role
<a name="cor-table-slr"></a>

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](https://docs.aws.amazon.com/cost-management/latest/userguide/data-exports-SLR.html) in the *AWS Cost Management User Guide*.

## AWS Organizations support
<a name="cor-table-organizations"></a>

Cost Optimization Hub integrates with AWS 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](https://docs.aws.amazon.com/cost-management/latest/userguide/coh-getting-started.html) in the *AWS Cost Management User Guide*.

The cost optimization recommendations table for a given AWS account inherits the same AWS 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 AWS account.

# Cost optimization recommendations columns
<a name="table-dictionary-cor-columns"></a>


| Column name | Description | Data type | Null value allowed | 
| --- | --- | --- | --- | 
| account\$1id | The account ID that the recommendation is for. | string | No | 
| account\$1name | The account name that the recommendation is for. | string | No | 
| action\$1type | The type of action you can take by adopting the recommendation. | string | No | 
| currency\$1code | The currency code used for the recommendation. | string | No | 
| current\$1resource\$1details | The details for the resource in JSON string format. | string | Yes | 
| current\$1resource\$1summary | A description of the current resource. | string | Yes | 
| current\$1resource\$1type | The type of resource. | string | Yes | 
| estimated\$1monthly\$1cost\$1after\$1discount | The estimated monthly cost of the current resource after discounts. For Reserved Instances and Savings Plans, it refers to the cost for eligible usage. | double | Yes | 
| estimated\$1monthly\$1cost\$1before\$1discount | The estimated monthly cost of the current resource before discounts. For Reserved Instances and Savings Plans, it refers to the cost for eligible usage. | double | No | 
| estimated\$1monthly\$1savings\$1after\$1discount | The estimated monthly savings amount for the recommendation after discounts. | double | Yes | 
| estimated\$1monthly\$1savings\$1before\$1discount | The estimated monthly savings amount for the recommendation before discounts. | double | No | 
| estimated\$1savings\$1percentage\$1after\$1discount | The estimated savings percentage after discounts relative to the total cost over the cost calculation lookback period. | double | Yes | 
| estimated\$1savings\$1percentage\$1before\$1discount | The estimated savings percentage before discounts relative to the total cost over the cost calculation lookback period. | double | No | 
| implementation\$1effort | The effort required to implement the recommendation. | string | No | 
| last\$1refresh\$1timestamp | The time when the recommendation was last generated. | timestamp | No | 
| recommendation\$1ID | The ID for the recommendation. | string | No | 
| recommendation\$1lookback\$1period\$1in\$1days | The lookback period that's used to generate the recommendation. | integer | No | 
| recommendation\$1source | The source of the recommendation. | string | No | 
| recommended\$1resource\$1details | The details about the recommended resource in JSON string format. | string | Yes | 
| recommended\$1resource\$1summary | A description of the recommended resource. | string | Yes | 
| recommended\$1resource\$1type | The resource type of the recommendation. | string | Yes | 
| region | The AWS Region of the resource. | string | Yes | 
| resource\$1arn | The Amazon Resource Name (ARN) of the resource. | string | Yes | 
| restart\$1needed | Whether or not implementing the recommendation requires a restart. | boolean | No | 
| rollback\$1possible | Whether or not implementing the recommendation can be rolled back. | boolean | No | 
| tags | A list of tags associated with the resource for which the recommendation exists. | map | Yes |