I’m trying since a couple of days to deploy the Health Events Dashboard and the support case dashboard but i’m always facing the same issue that i can’t solve.
ERROR - Failed fetching parameter data_collection_database_name, {‘type’: ‘athena’, ‘query’: “SELECT DISTINCT table_schema FROM information_schema.columns WHERE table_name = ‘support_cases_data’”, ‘default’: ‘optimization_data’, ‘description’: ‘Enter the name of the data collection database’, ‘global’: True}. Athena returns empty results. None
I already tried to update our data collection cloud formation stack but it didn’t fix the issue
Table support_cases_data might not exist in the database you are querying, or it might be in a different database/schema. Confirm that the table support_cases_data exists and is accessible in Athena.
Database name optimization_data might not contain the table. Double-check the database name configuration and ensure that the CloudFormation stack parameters align with the actual Athena database and tables.
If the table exists but is partitioned or its underlying S3 data location is incorrect or empty, Athena queries may return empty results. Verify the S3 bucket and prefix path used by the table and confirm that data exists at that location.
Please refer to the below documentations this might be helpful for you.
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Hello @Xclipse sorry for my late reply, i was quite busy these last months. So, i’d like to make you an update about this topic. I’ve tried to update the data collection stack, still KO, i’ve tried to remove the support cases and healths events modules and then re install them, still KO. I have this issue with only two dashboards, the other one are working fine. And i also confirm that the table “health_events_detail_data” or the “support_cases_data” are not existing into the Athena database “optimization_data”. The stepfunctions related to theses modules are working fine. But each time i’m trying to deploy the health events or support cases dashboard (with cli or through the cloud formation template) i’m facing the same issue.
“{‘type’: ‘athena’, ‘query’: “SELECT DISTINCT table_schema FROM information_schema.columns WHERE table_name = ‘health_events_detail_data’”, ‘error’: ‘This means that prerequisites for the dashboard are not found. Please make sure you have the needed table: Data Collection installed, needed module is configured and Step Function runs correctly.’, ‘default’: ‘optimization_data’, ‘description’: ‘Enter the name of the data collection database’, ‘global’: True}}”