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


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ò

asked 2 years ago284 views
1 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.

profile pictureAWS
answered 2 years ago

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