Table Not Found When Using Athena with Amazon QuickSight - Amazon QuickSight

Table Not Found When Using Athena with Amazon QuickSight

If you receive a "table not found" error, this can happen if the tables in an analysis are missing from the Athena data source.

In the https://console.aws.amazon.com/athena/, check for your table under the corresponding schema. You can recreate the table in Athena and then create a new dataset in Amazon QuickSight on that table. To investigate how the table was lost in the first place, you can use the Athena console to check the query history. This helps you find the queries that dropped the table.

If this error happened when you were editing a custom SQL query in preview, verify the name of the table in the query, and check for any other syntax errors. Amazon QuickSight can't infer the schema from the query. The schema must be specified in the query.

For example, the following statement works.

select from my_schema.my_table

The following statement fails because it's missing the schema.

select from my_table

If you still have an issue, verify that your tables, columns, and queries comply with Athena's requirements. For more information, see Names for Tables, Databases, and Columns and Troubleshooting in the Athena User Guide.