AWS Builder Center is the official home for builders on AWS. Share and read what others are working on, follow people who inspire you, explore training and workshops, and find tools to support what you're building.
Permission denied to SELECT from table despite giving AWS account permissions
When trying to run queries in Athena for a table, I'm getting this error: COLUMN_NOT_FOUND: Column didn't include column name cannot be resolved or requester is not authorized to access requested resources I went into Lake Formation for the account the table is on and granted select permissions to the ARN that I am running Athena from, but I am still getting that error. Do I need to grant permission elsewhere?
- Language
- English
asked 2 months ago58 views
- Newest
- Most votes
- Most comments
Verify it's actually a permissions issue. Run: DESCRIBE database.table;
If these fail with the same error, it's almost certainly permissions rather than a SQL issue.
Lake Formation permissions Make sure the principal you're granting to has:
- DESCRIBE on the database
- DESCRIBE on the table (or inherited)
- SELECT on the table
If using column-level permissions, ensure the specific columns are included. A common mistake is granting only SELECT without DESCRIBE.
Relevant content
- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated a year ago
The DESCRIBE command worked, but the SELECT command is still returning the same issue. The principal has Select and Describe permissions for Table and Column level