"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

Enter image description here

asked 2 months ago28 views
1 Answer

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/

profile picture
answered 2 months ago
  • 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?

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