aws.ce.get_savings_plan_purchase_recommendation_details

Example SQL Queries

SELECT * FROM
aws.ce.get_savings_plan_purchase_recommendation_details
WHERE
"recommendation_detail_id" = 'VALUE';

Description

Retrieves the details for a Savings Plan recommendation. These details include the hourly data-points that construct the cost, coverage, and utilization charts.

• View All Cost Explorer Tables
• Boto3 Reference

Table Definition

Column Name	Column Data Type
recommendation_detail_id Required Input Column The ID that is associated with the Savings Plan recommendation.	VARCHAR
_aws_profile Input Column The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.	STRUCT( "type" VARCHAR, "name" VARCHAR, "account_id" VARCHAR, "via_profile_name" VARCHAR, "assumed_role_arn" VARCHAR, "organization" STRUCT( "account_name" VARCHAR, "id" VARCHAR, "tags" STRUCT( "key" VARCHAR, "value" VARCHAR )[], "master_account" STRUCT( "id" VARCHAR, "email" VARCHAR ), "parents" STRUCT( "type" VARCHAR, "id" VARCHAR, "name" VARCHAR, "tags" STRUCT( "key" VARCHAR, "value" VARCHAR )[] )[] ) )
Show child fields _aws_profile.account_id The AWS account id _aws_profile.assumed_role_arn The ARN of the assumed role _aws_profile.name The unique name of the profile. _aws_profile.organization Information about this profile's membership in the AWS organization. Show child fields _aws_profile.organization.account_name The name of account speciifed by the organization _aws_profile.organization.id The organization id _aws_profile.organization.master_account Show child fields _aws_profile.organization.master_account.email The organization master account email address _aws_profile.organization.master_account.id The organization master account id _aws_profile.organization.parents[] Show child fields _aws_profile.organization.parents[].id The id of the parent _aws_profile.organization.parents[].name The name of the parent _aws_profile.organization.parents[].tags[] Show child fields _aws_profile.organization.parents[].tags[].key _aws_profile.organization.parents[].tags[].value _aws_profile.organization.parents[].type The type of parent can be an organization unit or a root _aws_profile.organization.tags[] Show child fields _aws_profile.organization.tags[].key _aws_profile.organization.tags[].value _aws_profile.type The type of profile, either 'credentials' or 'assumed_role' _aws_profile.via_profile_name This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.
recommendation_detail_data Contains detailed information about a specific Savings Plan recommendation.	STRUCT( "account_scope" VARCHAR, "lookback_period_in_days" VARCHAR, "savings_plans_type" VARCHAR, "term_in_years" VARCHAR, "payment_option" VARCHAR, "account_id" VARCHAR, "currency_code" VARCHAR, "instance_family" VARCHAR, "region" VARCHAR, "offering_id" VARCHAR, "generation_timestamp" VARCHAR, "latest_usage_timestamp" VARCHAR, "current_average_hourly_on_demand_spend" VARCHAR, "current_maximum_hourly_on_demand_spend" VARCHAR, "current_minimum_hourly_on_demand_spend" VARCHAR, "estimated_average_utilization" VARCHAR, "estimated_monthly_savings_amount" VARCHAR, "estimated_on_demand_cost" VARCHAR, "estimated_on_demand_cost_with_current_commitment" VARCHAR, "estimated_roi" VARCHAR, "estimated_sp_cost" VARCHAR, "estimated_savings_amount" VARCHAR, "estimated_savings_percentage" VARCHAR, "existing_hourly_commitment" VARCHAR, "hourly_commitment_to_purchase" VARCHAR, "upfront_cost" VARCHAR, "current_average_coverage" VARCHAR, "estimated_average_coverage" VARCHAR, "metrics_over_lookback_period" STRUCT( "start_time" VARCHAR, "estimated_on_demand_cost" VARCHAR, "current_coverage" VARCHAR, "estimated_coverage" VARCHAR, "estimated_new_commitment_utilization" VARCHAR )[] )
Show child fields recommendation_detail_data.account_id The AccountID that the recommendation is generated for. recommendation_detail_data.account_scope The account scope that you want your recommendations for. Amazon Web Services calculates recommendations including the management account and member accounts if the value is set to PAYER. If the value is LINKED, recommendations are calculated for individual member accounts only. recommendation_detail_data.currency_code The currency code that Amazon Web Services used to generate the recommendation and present potential savings. recommendation_detail_data.current_average_coverage The average value of hourly coverage over the lookback period. recommendation_detail_data.current_average_hourly_on_demand_spend The average value of hourly On-Demand spend over the lookback period of the applicable usage type. recommendation_detail_data.current_maximum_hourly_on_demand_spend The highest value of hourly On-Demand spend over the lookback period of the applicable usage type. recommendation_detail_data.current_minimum_hourly_on_demand_spend The lowest value of hourly On-Demand spend over the lookback period of the applicable usage type. recommendation_detail_data.estimated_average_coverage The estimated coverage of the recommended Savings Plan. recommendation_detail_data.estimated_average_utilization The estimated utilization of the recommended Savings Plan. recommendation_detail_data.estimated_monthly_savings_amount The estimated monthly savings amount based on the recommended Savings Plan. recommendation_detail_data.estimated_on_demand_cost The remaining On-Demand cost estimated to not be covered by the recommended Savings Plan, over the length of the lookback period. recommendation_detail_data.estimated_on_demand_cost_with_current_commitment The estimated On-Demand costs you expect with no additional commitment, based on your usage of the selected time period and the Savings Plan you own. recommendation_detail_data.estimated_roi The estimated return on investment that's based on the recommended Savings Plan that you purchased. This is calculated as estimatedSavingsAmount/estimatedSPCost*100. recommendation_detail_data.estimated_savings_amount The estimated savings amount that's based on the recommended Savings Plan over the length of the lookback period. recommendation_detail_data.estimated_savings_percentage The estimated savings percentage relative to the total cost of applicable On-Demand usage over the lookback period. recommendation_detail_data.estimated_sp_cost The cost of the recommended Savings Plan over the length of the lookback period. recommendation_detail_data.existing_hourly_commitment The existing hourly commitment for the Savings Plan type. recommendation_detail_data.generation_timestamp The period of time that you want the usage and costs for. recommendation_detail_data.hourly_commitment_to_purchase The recommended hourly commitment level for the Savings Plan type and the configuration that's based on the usage during the lookback period. recommendation_detail_data.instance_family The instance family of the recommended Savings Plan. recommendation_detail_data.latest_usage_timestamp The period of time that you want the usage and costs for. recommendation_detail_data.lookback_period_in_days How many days of previous usage that Amazon Web Services considers when making this recommendation. recommendation_detail_data.metrics_over_lookback_period[] Show child fields recommendation_detail_data.metrics_over_lookback_period[].current_coverage The current amount of Savings Plans eligible usage that the Savings Plan covered. recommendation_detail_data.metrics_over_lookback_period[].estimated_coverage The estimated coverage amount based on the recommended Savings Plan. recommendation_detail_data.metrics_over_lookback_period[].estimated_new_commitment_utilization The estimated utilization for the recommended Savings Plan. recommendation_detail_data.metrics_over_lookback_period[].estimated_on_demand_cost The remaining On-Demand cost estimated to not be covered by the recommended Savings Plan, over the length of the lookback period. recommendation_detail_data.metrics_over_lookback_period[].start_time The period of time that you want the usage and costs for. recommendation_detail_data.offering_id The unique ID that's used to distinguish Savings Plans from one another. recommendation_detail_data.payment_option The payment option for the commitment (for example, All Upfront or No Upfront). recommendation_detail_data.region The region the recommendation is generated for. recommendation_detail_data.savings_plans_type The requested Savings Plan recommendation type. recommendation_detail_data.term_in_years The term of the commitment in years. recommendation_detail_data.upfront_cost The upfront cost of the recommended Savings Plan, based on the selected payment option.

Note

Tables may require input columns to have values specified before the table can return it’s rows. The values for input parameters are set in the where clause of the query typically using = or IN.