Error while deploying CID Dashboards using manual deployment method

Question

I am following this link for the same wherein I am going with manual deployment option:

https://www.wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/dashboards/alternative_deployments/

Everything is going as per the instructions.

However at the last step, wherein i am describing my dashboard using below command:

aws quicksight describe-dashboard --dashboard-id cost_intelligence_dashboard_v01 --region us-east-1 --aws-account-id

"Errors": [
                {
                    "Type": "COLUMN_GEOGRAPHIC_ROLE_MISMATCH",
                    "Message": "Required geographic role for column 'region' in data set 'arn:aws:quicksight:us-east-1::dataset/fefaa87a-45de-4955-aa30-380ab17642d7' is 'STATE'"
                }
            ],
            "VersionNumber": 1,
            "Status": "CREATION_FAILED",

Dataset fefaa87a-45de-4955-aa30-380ab17642d7 is summary_view dataset.

Answer

I have got the solution,

This error can be rectified, by going to the Quick sight, open the dataset, select Edit Dataset.

From left side, columns list, check the geospatial type for "region" column.

Ensure that it is set as "State"

Answer

Ho, this should help you fix your error: https://www.wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/faq/#how-do-i-fix-the-column_geographic_role_mismatch-error

Error while deploying CID Dashboards using manual deployment method

Relevant content