Getting SCHEMA_NOT_FOUND error for Athena data source

Q&A
,
1

When created a dataset from Athena data source , I am able to view schema, table and actual records in schema explorer view. But when I run the custom SQL, it is throwing an error saying schema not found.

Query run: select * FROM “bodl-wowza-prod”.“license_fact” f limit 5

Error thrown:

|region:|us-east-1|
|timestamp:|1736657717777|
|requestId:|dee9e05b-0b38-48bf-a70e-1aba6e3da3b2|
|sourceErrorCode:|100071|
|sourceErrorMessage:|[Simba]AthenaJDBC An error has been thrown from the AWS Athena client. SCHEMA_NOT_FOUND: line 2:34: Schema ‘bodl-wowza-prod’ does not exist [Execution ID: bcee0f3f-a421-47d0-a9ef-f6732bf33c5b]|
|sourceErrorState:|HY000|
|sourceException:|java.sql.SQLException|
|sourceType:|ATHENA|

Doesn’t look like it is a permission issue as schema explorer is showing the schema -bodl-wowza-prod, table-license_fact and it’s records.

Please help.

Thanks,
Manoj G

2

Hi @mgundawar

Welcome to the QuickSight community!

Could you please include the catalog name as well. For example: catalog1.database1.table1. You can try using the following query format.

Note: Replace the AWS data catalog name from your account

SELECT * FROM AWSDataCatalog."bodl-wowza-prod"."license_fact";
4

Hi Xclipse,

Thanks a lot for your reply and solution.
It solved my issue.

Thanks again.
Manoj G.

1 Like