Athena Query Generic User Error

Question

I am trying to query data in my own account and am getting the following error:

```GENERIC_USER_ERROR: Cannot execute query. User in account  is not authorized for any columns in table ```

Has anyone experienced this before, or otherwise have any insight as to why this may be occurring? It is a lake formation governed table

Answer

One possible reason could be Lake formation permissions that are needed for user for the database table level. Try the below steps and let me know if you still face any issues:

**STEP 1: Table access**

To grant access, please Go to "AWS Lake Formation" > "Data Lake permissions"

Choose the IAM users and roles from drop down

Choose Named data catalog resources

Choose Table(s) and provide "Select" & "Describe"  access (or more as needed)

If it is not resolved, proceed to Step 2

**STEP 2: Database access**

To grant access, please Go to "AWS Lake Formation" > "Data Lake permissions"

Choose the IAM users and roles from drop down

Choose Named data catalog resources

Choose database (dont choose tables) and provide "Describe"  access (or more as needed)

Athena Query Generic User Error

Relevant content