By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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

0

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ò

Topics
AnalyticsDatabase
Tags
AnalyticsAmazon QuickSightDatabase
Language
English
rePost-User-4632342
asked 2 years ago292 views
1 Answer
0

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
Ananth Tirumanur
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

Relevant content