Error in Athena: database does not exist

I have faced this issue earlier and I feel the error message here is misleading. I was able to resolve this issue by providing access to the database and tables through Lakeformation. Let me explain what I had to do:

• Do you have Lake formation turned on? If so, you would have to provide Database level and table level access from there. The fact that you are seeing your databases and tables implies that you have you have describe access on the database/table but not select access.
• You don't have lakeformation turned on? Check if your user/role has these permissions: "glue:GetDatabases", "glue:GetDatabase","glue:GetTables", "glue:GetPartitions","glue:GetPartition","glue:GetTable"
• In some cases, this could be due to compatibility of the table such as XML table - https://aws.amazon.com/premiumsupport/knowledge-center/athena-glue-tables-not-visible/
• If you still have the issue, verify that your tables, columns, and queries comply with Athena requirements. For more information, see Names for Tables, Databases, and Columns and Troubleshooting in the Athena User Guide.