Error to view table

Question

After using a crawler to create a table it shows the following error which I don't know how to fix.

![Error](/media/postImages/original/IMr9UNFbk4Q-qth24BoQLcPQ)

Answer

This is a typically 
* a permission issue (Resolve it by adding the permissions in AWS Lake Formation. Under Data Lake Permissions, make sure your user has atleast the 'Describe' and 'Select' permissions on the database **and** the table.) 
* or a Table definition issue (Check with `SHOW CREATE TABLE` statement).

Please refer to [AWS Support Article](https://aws.amazon.com/premiumsupport/knowledge-center/athena-syntax-error-select-not-allowed/)

Error to view table

Conteúdo relevante