- Newest
- Most votes
- Most comments
lineItem/NetUnblendedCost: The actual after-discount cost that you're paying for the line item. This column is included in your report only when your account has a discount in the applicable billing period.
If you cannot see it, please check if you have a discount in that billing period.
The line_item_net_unblended_cost is part of customer_all table but this is a direct query and it is not in summary_view.
Also, that will nto resolve your issue but I'd recommend you go through the new automated setup to get the updated version: https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/
You can modify the summary_view in Athena to bring in additional fields to the view that you want. This video on adding in tag fields to the summary view will give you the steps to pull in additional fields. In Athena you also have the source CUR table that you can reference as a datasets if you want to query against all of the fields. Depending on the size of your CUR data, that could result in a lot more data to pull in. I would start with the fields you want to include into the summary view and work backwards to see if you need all the fields from CUR. You can also use the Amazon Athena Power BI connector to connect to the CUR table with all of your CUR data.
Relevant content
- asked a year ago
AWS OFFICIALUpdated a month ago- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
thanks Jonathan--- will the customer_all table be available if I implement the new automated setup?
it should yes, you can also follow Stephen' suggestion to edit your summary view to add the field you want. Or build a new summary_view view in Athena that contains the new field. You can show/edit the query in Athena and edit the query to add the calculation you want.