Unable to refresh Quicksight dataset. ERROR: Query (39995467) cancelled on user's request

Question

Hello, 
I am not able to refresh the dataset anymore receiving the following error message:
This is a general SQL error. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.
Source error message:
ERROR: Query (39995467) cancelled on user's request
SQL queries behind are working correctly, how can I dive deep and fix it?
Thanks a lot
Nicolò

Answer

If you open up the Athena console and check the query history, you should be able to locate the queries that were executed at the time of the Quicksight dashboard refresh. Try refreshing the dashboard once while you have the Athena query history open. Here each query that executes in Athena would be listed and you should be able to see detailed query errors as well that would help identify which queries are timing out or erroring out.

Unable to refresh Quicksight dataset. ERROR: Query (39995467) cancelled on user's request

Contenuto pertinente