Quick sight : No Athena tables found

The issue you're experiencing with Amazon QuickSight not finding any Athena tables could be due to several reasons. Here are some troubleshooting steps and potential solutions:

1. Check the Athena console: Verify that your tables are actually present in the Athena console. Sometimes tables can be accidentally dropped or renamed.

2. Refresh the dataset: In QuickSight, open your analysis, go to the "Visualize" tab, choose "Choose dataset," then "Edit analysis data sets." On the "Data sets in this analysis" screen, choose "Edit" near your dataset to refresh it. QuickSight caches the schema for two minutes, so it may take a short while for changes to appear.

3. Verify table and schema names: Ensure that the table names and schemas in your Athena queries are correct and match exactly with what's in the Athena console.

4. Check custom SQL queries: If you're using custom SQL, make sure you've specified both the schema and table name correctly. For example, "select * from my_schema.my_table" works, but "select * from my_table" might fail if the schema isn't specified.

5. Athena requirements: Verify that your tables, columns, and queries comply with Athena requirements. You can find more information on this in the Athena User Guide.

6. Permissions: Although you've granted administrator permissions to the QuickSight service role via IAM and given Lake Formation permissions, double-check that these permissions are correctly applied and that there are no conflicting policies.

7. Workgroup settings: Ensure that the Athena workgroup settings are correctly configured and that QuickSight has access to the appropriate workgroup.

If you've tried these steps and are still encountering issues, you may want to check the Athena query history in the Athena console to see if there are any queries that might have affected your tables. Additionally, running your queries directly in the Athena console before adding them to QuickSight can help isolate whether the issue is with Athena or QuickSight.

If the problem persists, you may need to contact AWS support for further assistance, as there could be account-specific issues that aren't immediately apparent.
Sources
Table not found when using Athena with Amazon QuickSight - Amazon QuickSight
Column not found when using Athena with Amazon QuickSight - Amazon QuickSight
Connectivity issues when using Amazon Athena with Amazon QuickSight - Amazon QuickSight