ComputeOptimizer / Client / export_rds_database_recommendations

export_rds_database_recommendations#

ComputeOptimizer.Client.export_rds_database_recommendations(**kwargs)#

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 Amazon Web Services Region.

See also: AWS API Documentation

Request Syntax

response = client.export_rds_database_recommendations(
    accountIds=[
        'string',
    ],
    filters=[
        {
            'name': 'InstanceFinding'|'InstanceFindingReasonCode'|'StorageFinding'|'StorageFindingReasonCode'|'Idle',
            'values': [
                'string',
            ]
        },
    ],
    fieldsToExport=[
        'ResourceArn'|'AccountId'|'Engine'|'EngineVersion'|'Idle'|'MultiAZDBInstance'|'CurrentDBInstanceClass'|'CurrentStorageConfigurationStorageType'|'CurrentStorageConfigurationAllocatedStorage'|'CurrentStorageConfigurationMaxAllocatedStorage'|'CurrentStorageConfigurationIOPS'|'CurrentStorageConfigurationStorageThroughput'|'CurrentInstanceOnDemandHourlyPrice'|'CurrentStorageOnDemandMonthlyPrice'|'LookbackPeriodInDays'|'CurrentInstancePerformanceRisk'|'UtilizationMetricsCpuMaximum'|'UtilizationMetricsMemoryMaximum'|'UtilizationMetricsEBSVolumeStorageSpaceUtilizationMaximum'|'UtilizationMetricsNetworkReceiveThroughputMaximum'|'UtilizationMetricsNetworkTransmitThroughputMaximum'|'UtilizationMetricsEBSVolumeReadIOPSMaximum'|'UtilizationMetricsEBSVolumeWriteIOPSMaximum'|'UtilizationMetricsEBSVolumeReadThroughputMaximum'|'UtilizationMetricsEBSVolumeWriteThroughputMaximum'|'UtilizationMetricsDatabaseConnectionsMaximum'|'UtilizationMetricsStorageNetworkReceiveThroughputMaximum'|'UtilizationMetricsStorageNetworkTransmitThroughputMaximum'|'UtilizationMetricsAuroraMemoryHealthStateMaximum'|'UtilizationMetricsAuroraMemoryNumDeclinedSqlTotalMaximum'|'UtilizationMetricsAuroraMemoryNumKillConnTotalMaximum'|'UtilizationMetricsAuroraMemoryNumKillQueryTotalMaximum'|'UtilizationMetricsReadIOPSEphemeralStorageMaximum'|'UtilizationMetricsWriteIOPSEphemeralStorageMaximum'|'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'|'DBClusterIdentifier'|'PromotionTier',
    ],
    s3DestinationConfig={
        'bucket': 'string',
        'keyPrefix': 'string'
    },
    fileFormat='Csv',
    includeMemberAccounts=True|False,
    recommendationPreferences={
        'cpuVendorArchitectures': [
            'AWS_ARM64'|'CURRENT',
        ]
    }
)
Parameters:

  • accountIds (list) –

    The Amazon Web Services 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.

    • (string) –

  • filters (list) –

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

    • (dict) –

      Describes a filter that returns a more specific list of Amazon RDS recommendations. Use this filter with the GetECSServiceRecommendations action.

      • name (string) –

        The name of the filter.

        Specify Finding to return recommendations with a specific finding classification.

        You can filter your Amazon RDS recommendations by tag:key and tag-key tags.

        A tag:key is a key and value combination of a tag assigned to your Amazon RDS recommendations. Use the tag key in the filter name and the tag value as the filter value. For example, to find all Amazon RDS service recommendations that have a tag with the key of Owner and the value of TeamA, specify tag:Owner for the filter name and TeamA for the filter value.

        A tag-key is the key of a tag assigned to your Amazon RDS recommendations. Use this filter to find all of your Amazon RDS recommendations that have a tag with a specific key. This doesn’t consider the tag value. For example, you can find your Amazon RDS service recommendations with a tag key value of Owner or without any tag keys assigned.

      • values (list) –

        The value of the filter.

        • (string) –

  • fieldsToExport (list) –

    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.

    • (string) –

  • s3DestinationConfig (dict) –

    [REQUIRED]

    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.

    • bucket (string) –

      The name of the Amazon S3 bucket to use as the destination for an export job.

    • keyPrefix (string) –

      The Amazon S3 bucket prefix for an export job.

  • fileFormat (string) –

    The format of the export file.

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

  • includeMemberAccounts (boolean) –

    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 Amazon Web Services Organizations trusted access in the 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.

  • recommendationPreferences (dict) –

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

    • cpuVendorArchitectures (list) –

      Specifies the CPU vendor and architecture for Amazon EC2 instance and Auto Scaling group recommendations.

      For example, when you specify AWS_ARM64 with:

      • A GetEC2InstanceRecommendations or GetAutoScalingGroupRecommendations request, Compute Optimizer returns recommendations that consist of Graviton instance types only.

      • A GetEC2RecommendationProjectedMetrics request, Compute Optimizer returns projected utilization metrics for Graviton instance type recommendations only.

      • A ExportEC2InstanceRecommendations or ExportAutoScalingGroupRecommendations request, Compute Optimizer exports recommendations that consist of Graviton instance types only.

      • (string) –

Return type:

dict

Returns:

Response Syntax

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

Response Structure

  • (dict) –

    • jobId (string) –

      The identification number of the export job.

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

    • s3Destination (dict) –

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

      • bucket (string) –

        The name of the Amazon S3 bucket used as the destination of an export file.

      • key (string) –

        The Amazon S3 bucket key of an export file.

        The key uniquely identifies the object, or export file, in the S3 bucket.

      • metadataKey (string) –

        The Amazon S3 bucket key of a metadata file.

        The key uniquely identifies the object, or metadata file, in the S3 bucket.

Exceptions