"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
- 最新
- 投票最多
- 评论最多
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/
相关内容
AWS 官方已更新 1 年前- AWS 官方已更新 3 年前
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?