Request Syntax Request Parameters Response Syntax Response Elements Errors See Also

ExportRDSDatabaseRecommendations

Export optimization recommendations for your Amazon Relational Database Service (Amazon RDS).

Recommendations are exported in a comma-separated values (CSV) file, and its metadata in a JavaScript Object Notation (JSON) file, to an existing Amazon Simple Storage Service (Amazon S3) bucket that you specify. For more information, see Exporting Recommendations in the Compute Optimizer User Guide.

You can have only one Amazon RDS export job in progress per AWS Region.

Request Syntax


{
   "accountIds": [ "string" ],
   "fieldsToExport": [ "string" ],
   "fileFormat": "string",
   "filters": [ 
      { 
         "name": "string",
         "values": [ "string" ]
      }
   ],
   "includeMemberAccounts": boolean,
   "recommendationPreferences": { 
      "cpuVendorArchitectures": [ "string" ]
   },
   "s3DestinationConfig": { 
      "bucket": "string",
      "keyPrefix": "string"
   }
}

Request Parameters

For information about the parameters that are common to all actions, see Common Parameters.

The request accepts the following data in JSON format.

accountIds

The AWS account IDs for the export Amazon RDS recommendations.

If your account is the management account or the delegated administrator of an organization, use this parameter to specify the member account you want to export recommendations to.

This parameter can't be specified together with the include member accounts parameter. The parameters are mutually exclusive.

If this parameter or the include member accounts parameter is omitted, the recommendations for member accounts aren't included in the export.

You can specify multiple account IDs per request.

Type: Array of strings

Required: No

fieldsToExport

The recommendations data to include in the export file. For more information about the fields that can be exported, see Exported files in the Compute Optimizer User Guide.

Type: Array of strings

Valid Values: ResourceArn | AccountId | Engine | EngineVersion | Idle | MultiAZDBInstance | CurrentDBInstanceClass | CurrentStorageConfigurationStorageType | CurrentStorageConfigurationAllocatedStorage | CurrentStorageConfigurationMaxAllocatedStorage | CurrentStorageConfigurationIOPS | CurrentStorageConfigurationStorageThroughput | CurrentInstanceOnDemandHourlyPrice | CurrentStorageOnDemandMonthlyPrice | LookbackPeriodInDays | UtilizationMetricsCpuMaximum | UtilizationMetricsMemoryMaximum | UtilizationMetricsEBSVolumeStorageSpaceUtilizationMaximum | UtilizationMetricsNetworkReceiveThroughputMaximum | UtilizationMetricsNetworkTransmitThroughputMaximum | UtilizationMetricsEBSVolumeReadIOPSMaximum | UtilizationMetricsEBSVolumeWriteIOPSMaximum | UtilizationMetricsEBSVolumeReadThroughputMaximum | UtilizationMetricsEBSVolumeWriteThroughputMaximum | UtilizationMetricsDatabaseConnectionsMaximum | InstanceFinding | InstanceFindingReasonCodes | StorageFinding | StorageFindingReasonCodes | InstanceRecommendationOptionsDBInstanceClass | InstanceRecommendationOptionsRank | InstanceRecommendationOptionsPerformanceRisk | InstanceRecommendationOptionsProjectedUtilizationMetricsCpuMaximum | StorageRecommendationOptionsStorageType | StorageRecommendationOptionsAllocatedStorage | StorageRecommendationOptionsMaxAllocatedStorage | StorageRecommendationOptionsIOPS | StorageRecommendationOptionsStorageThroughput | StorageRecommendationOptionsRank | InstanceRecommendationOptionsInstanceOnDemandHourlyPrice | InstanceRecommendationOptionsSavingsOpportunityPercentage | InstanceRecommendationOptionsEstimatedMonthlySavingsCurrency | InstanceRecommendationOptionsEstimatedMonthlySavingsValue | InstanceRecommendationOptionsSavingsOpportunityAfterDiscountsPercentage | InstanceRecommendationOptionsEstimatedMonthlySavingsCurrencyAfterDiscounts | InstanceRecommendationOptionsEstimatedMonthlySavingsValueAfterDiscounts | StorageRecommendationOptionsOnDemandMonthlyPrice | StorageRecommendationOptionsSavingsOpportunityPercentage | StorageRecommendationOptionsEstimatedMonthlySavingsCurrency | StorageRecommendationOptionsEstimatedMonthlySavingsValue | StorageRecommendationOptionsSavingsOpportunityAfterDiscountsPercentage | StorageRecommendationOptionsEstimatedMonthlySavingsCurrencyAfterDiscounts | StorageRecommendationOptionsEstimatedMonthlySavingsValueAfterDiscounts | EffectiveRecommendationPreferencesCpuVendorArchitectures | EffectiveRecommendationPreferencesEnhancedInfrastructureMetrics | EffectiveRecommendationPreferencesLookBackPeriod | EffectiveRecommendationPreferencesSavingsEstimationMode | LastRefreshTimestamp | Tags

Required: No

fileFormat

The format of the export file.

The CSV file is the only export file format currently supported.

Type: String

Valid Values: Csv

Required: No

filters

An array of objects to specify a filter that exports a more specific set of Amazon RDS recommendations.

Type: Array of RDSDBRecommendationFilter objects

Required: No

includeMemberAccounts

If your account is the management account or the delegated administrator of an organization, this parameter indicates whether to include recommendations for resources in all member accounts of the organization.

The member accounts must also be opted in to Compute Optimizer, and trusted access for Compute Optimizer must be enabled in the organization account. For more information, see Compute Optimizer and AWS Organizations trusted access in the AWS Compute Optimizer User Guide.

If this parameter is omitted, recommendations for member accounts of the organization aren't included in the export file.

If this parameter or the account ID parameter is omitted, recommendations for member accounts aren't included in the export.

Type: Boolean

Required: No

recommendationPreferences

Describes the recommendation preferences to return in the response of a GetAutoScalingGroupRecommendations, GetEC2InstanceRecommendations, GetEC2RecommendationProjectedMetrics, GetRDSDatabaseRecommendations, and GetRDSDatabaseRecommendationProjectedMetrics request.

Type: RecommendationPreferences object

Required: No

s3DestinationConfig

Describes the destination Amazon Simple Storage Service (Amazon S3) bucket name and key prefix for a recommendations export job.

You must create the destination Amazon S3 bucket for your recommendations export before you create the export job. Compute Optimizer does not create the S3 bucket for you. After you create the S3 bucket, ensure that it has the required permission policy to allow Compute Optimizer to write the export file to it. If you plan to specify an object prefix when you create the export job, you must include the object prefix in the policy that you add to the S3 bucket. For more information, see Amazon S3 Bucket Policy for Compute Optimizer in the Compute Optimizer User Guide.

Type: S3DestinationConfig object

Required: Yes

Response Syntax


{
   "jobId": "string",
   "s3Destination": { 
      "bucket": "string",
      "key": "string",
      "metadataKey": "string"
   }
}

Response Elements

If the action is successful, the service sends back an HTTP 200 response.

The following data is returned in JSON format by the service.

jobId

The identification number of the export job.

To view the status of an export job, use the DescribeRecommendationExportJobs action and specify the job ID.

Type: String

s3Destination

Describes the destination Amazon Simple Storage Service (Amazon S3) bucket name and object keys of a recommendations export file, and its associated metadata file.

Type: S3Destination object

Errors

For information about the errors that are common to all actions, see Common Errors.

AccessDeniedException

You do not have sufficient access to perform this action.

HTTP Status Code: 400

InternalServerException

An internal error has occurred. Try your call again.

HTTP Status Code: 500

InvalidParameterValueException

The value supplied for the input parameter is out of range or not valid.

HTTP Status Code: 400

LimitExceededException

The request exceeds a limit of the service.

HTTP Status Code: 400

MissingAuthenticationToken

The request must contain either a valid (registered) AWS access key ID or X.509 certificate.

HTTP Status Code: 400

OptInRequiredException

The account is not opted in to AWS Compute Optimizer.

HTTP Status Code: 400

ServiceUnavailableException

The request has failed due to a temporary failure of the server.

HTTP Status Code: 500

ThrottlingException

The request was denied due to request throttling.

HTTP Status Code: 400