By using AWS re:Post, you agree to the Terms of Use

Identifying amortized cost column in AWS cost and usage report

0

Hello, We are ingesting CUR data for our own internal BI use cases. AWS Cost Explorer user interface provides a toggle to see amortized cost and net amortized cost for a resource. We want to surface the same in our inhouse BI dashboard. So in cost and usage report CSV, which is the column which reflects the above information for a resource ? Documentation is not very clear. What would the value of this column be for resources which does not have any RIs/discounts ? Any examples would help. Thanks.

2 Answers
0

The following help section in the Well Architected CUR Query Library has some good explanations: https://wellarchitectedlabs.com/cost/300_labs/300_cur_queries/query_help/

Also there is an amortized cost by charge type example here as well: https://wellarchitectedlabs.com/cost/300_labs/300_cur_queries/queries/global/

answered 9 months ago
0

Depending on whether account(s) have any RI or SP discount, you would need to use different columns for this as there's no one single "amortized cost" column in CUR. Here are few examples:

  • if there are RIs and there's usage that's benefiting from their discount, you would use column "reservation/EffectiveCost"
  • for SPs there's separate column for that - "savingsPlan/SavingsPlanEffectiveCost"
  • and for anything else, you would normally use "lineItem/UnblendedCost" (unless you know exactly why you need it, "lineItem/BlendedCost" can be used in some circumstances)

As for examples, check out CUR query library as mentioned by @amazonchris earlier https://wellarchitectedlabs.com/cost/300_labs/300_cur_queries/query_help/

profile picture
EXPERT
answered 8 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions