Getting error when trying to implement CUDOS Dashboard

Question

Hello, I am currently following the tutorial to set up a cudos dashboard with quicksight. I have completed the prerequisites and when i try to deploy CUD, I get this error ***line 39:206: Column 'product_instance_type_family' cannot be resolved
This query ran against the "athenacurcfn_new_cur" database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query Id: d8fbdfdc-cba2-4085-abbf-a0061df83452*** . This is the query result for line 39

**WHEN (("line_item_usage_type" LIKE '%Spot%') AND ("line_item_product_code" = 'AmazonEC2') AND ("line_item_line_item_type" = 'Usage')) THEN "split_part"("line_item_line_item_description", '.', 1) ELSE "product_instance_type_family" END "instance_type_family"**

The solution was deployed uisng cloudformation.

Answer

That is an odd error as its suggesting that that column is missing from your CUR file. I recommend deleting the stack and deploying it again with the latest version of the CFN available on the WA labs today.

Getting error when trying to implement CUDOS Dashboard

Contenuto pertinente