AWS FlexReport AI/ML Cloud Cost returns "Column: lineItem_NetUnblendedCost does not exist in AWS_CUR. Please use the correct readable name for the column."

Products

• CloudHealth

Issue/Introduction

The following AWS FlexReport - AI/ML Cloud Cost can sometimes return the error - "Column: lineItem_NetUnblendedCost does not exist in AWS_CUR. Please use the correct readable name for the column."

This would indicate that you do not have discounts being automated by AWS.

Resolution

In order to resolve the issue you can instead use the Unblended Cost field by implementing the following updated query:

{
"sqlStatement": "SELECT timeInterval_Month AS Month, SUM(lineItem_UnblendedCost) AS SUM_lineItem_UnblendedCost, lineItem_LineItemDescription AS LineItem_LineItemDescription, lineItem_Operation AS LineItem_Operation, lineItem_ProductCode AS LineItem_ProductCode, lineItem_UsageType AS LineItem_UsageType, lineItem_UsageAccountId AS LineItem_UsageAccountId, organization.accountname AS Organization_accountname FROM AWS_CUR WHERE ((LOWER(lineItem_ProductCode) LIKE '%sagemaker%') OR (LOWER(lineItem_ProductCode) LIKE '%comprehend%') OR (LOWER(lineItem_ProductCode) LIKE '%amazonpolly%') OR (LOWER(lineItem_ProductCode) LIKE '%amazonlex%') OR (LOWER(lineItem_ProductCode) LIKE '%amazonrekognition%') OR (LOWER(lineItem_ProductCode) LIKE '%translate%') OR (LOWER(lineItem_ProductCode) LIKE '%amazonbedrock%') OR (LOWER(lineItem_ProductCode) LIKE '%amazona2i%') OR (LOWER(lineItem_ProductCode) LIKE '%codeguru%') OR (LOWER(lineItem_ProductCode) LIKE '%amazondevopsguru%') OR (LOWER(lineItem_ProductCode) LIKE '%amazonkendra%') OR (LOWER(lineItem_ProductCode) LIKE '%monitron%') OR (LOWER(lineItem_ProductCode) LIKE '%partyrock%') OR (LOWER(lineItem_ProductCode) LIKE '%personalize%') OR (LOWER(lineItem_ProductCode) LIKE '%mxnet%') OR (LOWER(lineItem_ProductCode) LIKE '%deeplearning%') OR (LOWER(lineItem_ProductCode) LIKE '%tensorflow%') OR (LOWER(lineItem_ProductCode) LIKE '%textract%') OR (LOWER(lineItem_ProductCode) LIKE '%transcribe%') OR (LOWER(lineItem_ProductCode) LIKE '%deepcomposer%') OR (LOWER(lineItem_ProductCode) LIKE '%deeplens%') OR (LOWER(lineItem_ProductCode) LIKE '%deepracer%') OR (LOWER(lineItem_ProductCode) LIKE '%healthlake%') OR (LOWER(lineItem_ProductCode) LIKE '%healthscribe%') OR (LOWER(lineItem_ProductCode) LIKE '%panorama%')) GROUP BY timeInterval_Month, lineItem_LineItemDescription, lineItem_Operation, lineItem_ProductCode, lineItem_UsageType, lineItem_UsageAccountId, organization.accountname",
"needBackLinkingForTags": true,
"dataGranularity": "MONTHLY",
"timeRange": {
"last": 12
},
"limit": -1
}

This query should build in cases where the Net Fields are not showing due to a lack of discount automation.