Quick Sight Datasets error #21
Description
Hello everyone,
I deployed the Dashboard with the "Deployment: Dashboard account" option.
The Environment has a Control Tower setup and therefore has standard AWS Config delivery channels. CID, CUDOS, and KPI Dashboards are also deployed and working.
However, for the AWS Config Resource Compliance Dashboard, I am getting this error for all QuickSight dataset refreshes:
Refresh error details
Ingestion Id
7f72aa10-10bc-474c-9a7b-5be9cccf5ad1
Error type:
SQL_EXCEPTION Learn more
This is a general SQL error. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.
Error details:
INVALID_VIEW: line 9:6: Failed analyzing stored view 'awsdatacatalog.cid_crcd_database.config_inventory_account': line 6:3: Failed analyzing stored view 'awsdatacatalog.cid_crcd_database.config_sys_account_data': line 6:3: Table 'awsdatacatalog.cid_cur.account_map' does not exist [Execution ID: 9f12dfd6-8908-4d99-b9ff-d6342a48df6a]
Can someone help here?