Skip to content

Error when creating CUDOS dashboard through CLI: "Type": "COLUMN_REPLACEMENT_MISSING", "Message": "Required column 'database_engine' is missing in data set

0

I'm following the Well Architected Lab religiously: https://www.wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/

When trying the create the CUDOS dashboards from the CLI after creating the 4 different views through the AWS Athena, it provided an error: "Type": "COLUMN_REPLACEMENT_MISSING", "Message": "Required column 'database_engine' is missing in data set, but nowhere through the process this type of column was created in any of the views, nor does it exist in the CUR database i created.

1 Answer
0

Hi AnnaZats, database_engine is used in summary_view and kpi dashboard views. The problem occurs in case you don't have any RDS usage and deploy via CLI. We've added a workaround for this in our CloudFormation deployment hence I recommend to follow our guide step by step and deploy with cloudformation template as described here. In this case CloudFormation template #3 from the deployment guide creates Athena table for Cost and Usage report and includes database_engine column as well. Here is the place of the CFN where this column is part of the schema.

If you have CUR table already and deploying with cid-cmd then you might need to open your CUR table definition in CUR and manually add column product_database_engine with STRING type. After that deployment should work, however I recommend to stick to first approach which I described above.

AWS
EXPERT
answered 2 years 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.