Amazon Cost Explorer helps you visualize, understand, and manage your AWS costs and usage. The
aws_cost_forecast_monthly table retrieves a forecast for how much Amazon Web Services predicts that you will spend each month over the next 12 months, based on your past costs.
Note that pricing for the Cost Explorer API is per API request - Each request will incur a cost of $0.01.
Month on month forecasted growth
with cost_data as (selectperiod_start,mean_value as this_month,lag(mean_value,-1) over(order by period_start desc) as previous_monthfromaws_cost_forecast_monthly)selectperiod_start,this_month::numeric::money,previous_month::numeric::money,casewhen previous_month = 0 and this_month = 0 then 0when previous_month = 0 then 999else round((100 * ( (this_month - previous_month) / previous_month))::numeric, 2)end as percent_changefromcost_dataorder byperiod_start;
AWS Cost Explorer - Cost Forecast (Monthly)
|_ctx||jsonb||Steampipe context in JSON form, e.g. connection_name.|
|account_id||text||The AWS Account ID in which the resource is located.|
|mean_value||double precision||Average forecasted value|
|partition||text||The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).|
|period_end||timestamp with time zone||End timestamp for this cost metric|
|period_start||timestamp with time zone||Start timestamp for this cost metric|
|region||text||The AWS Region in which the resource is located.|