By using AWS re:Post, you agree to the Terms of Use

Athena Query Generic User Error

0

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 <account id> is not authorized for any columns in table <table_name>

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

1 Answer
0

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)

profile picture
answered 23 days ago
  • I'm having the exact same issue (Lake Formation managed Governed Table, generic user error, etc). Not only using the admin account with access to everything, but I specifically added the permissions as described on this answer, to no avail. Could there be something else that is causing this?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions