Cannot drop table in Athena that was accidentally created using Glue Crawler

Question

Trying to DROP TABLE in Athena and getting the following error:

[ErrorCategory:USER_ERROR, ErrorCode:PERMISSION_ERROR], Detail:Amazon Athena experienced a permission error. Please provide proper permission and submitting the query again. If the issue reoccurs, contact AWS support for further assistance.

I also tried deleting from Glue under tables and got this error:

Failed to delete all tables.
AccessDeniedException: Insufficient Lake Formation permission(s): Required Drop on [table name]

I went to Lake Formation and granted myself SUPER on the database I'm trying to delete from but I'm still getting the same errors.

Answer

Based on the errors, my best guess is that Lake formation access to DROP TABLE is missing. The database SUPER permissions that you have mentioned about is not enough. You would also need to provide access to the table (You can choose ALL TABLES in the particular database if needed). Please refer to:

https://docs.aws.amazon.com/lake-formation/latest/dg/granting-table-permissions.html

Cannot drop table in Athena that was accidentally created using Glue Crawler

Relevanter Inhalt