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ò

質問済み 2年前301ビュー
1回答
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
回答済み 2年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ