"SCHEMA_NOT_FOUND" Error in Athena
I'm getting a "SCHEMA_NOT_FOUND" error when trying to preview a table in Athena. Using the same connection, data source and database, I'm able to preview the table in a Glue DataBrew project so I know the table is populated and accessible . The Athena query is using Athena 3.0 in us-west-1. Any help would be appreciated!
SCHEMA_NOT_FOUND: line 1:15: Schema 'exp' does not exist
This query ran against the "EXP" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: 5f17ea48-4f09-4285-b8d2-aa0be96abe38
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
This is most probably due to access that your ID has (which Athena uses) versus the Glue Service Role that you have assigned to Glue Databrew. The service role has all the accesses needed. Check if you have these permissions:
"glue:GetDatabases", "glue:GetDatabase","glue:GetTables", "glue:GetPartitions","glue:GetPartition","glue:GetTable"
Do you have Lake formation turned on? If so, you would have to provide Database level and table level access from there.
In some cases, this could be due to compatibility of the table such as XML table - https://aws.amazon.com/premiumsupport/knowledge-center/athena-glue-tables-not-visible/
Contenuto pertinente
AWS UFFICIALEAggiornata 2 anni fa- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
Checking my ID I have the AWSGlueServiceRole which holds the permission "glue:*" and we don't have Lake formation turned on. Looking into the syntax of Athena, would the Database and table name being Capitalized be the issue?