Error in Athena: database does not exist
0
Hi !
I have been a long time trying to solve this error without success. I have already verified the existence of the database, the region, etc. Any help would be great. Thanks!
1 Answer
- Newest
- Most votes
- Most comments
1
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.
answered a year ago
Relevant content
- asked 8 months ago
AWS OFFICIALUpdated 3 years ago- AWS OFFICIALUpdated a month ago
Unfortunately this didn't work. I verified that the Lake formation is off, I have all the permissions needed in the user/role, my tables meet the formatting requirements and my tables and components comply with Athena requirements. If you discover another reason for the error would be great.