Error: COLUMN_NOT_FOUND: line 1:8: SELECT * not allowed from relation that has no columns

Question

Hello,
I have an Excel file stored in S3 bucket.
After running a crawler and creating a table I'm trying to see the table in Athena and getting this error:
COLUMN_NOT_FOUND: line 1:8: SELECT * not allowed from relation that has no columns.

How can I solve it?

Answer

It seems like the user does not have sufficient permissions.

Are you using Lake Formation?
If so, please check if SELECT access has been granted on the table level and 'Describe' has been granted at the database level.

Answer

You can also refer this re:post answer:

https://repost.aws/questions/QUQ712jy2XTX247bNBBU6WDg/athena-query-does-not-see-any-columns

Error: COLUMN_NOT_FOUND: line 1:8: SELECT * not allowed from relation that has no columns

Relevanter Inhalt