- 最新
- 最多得票
- 最多評論
Hello,
Regarding your query, if you are using a Direct Query Data set in Quicksight, you could be facing a timeout while loading your analysis and dashboards. As you are aware, there is a timeout of 2 minutes in Quicksight while generating visuals.
In this scenario, Quicksight would execute a query when you refresh the visual and if the query execution could not be completed within 2 minutes, the Quicksight would issue a timeout and the analysis will not be able to load.
Also, the timeout of 2 minutes is a hard limit and currently Quicksight does not support configuring a manual timeout for heavy queries.
[+] - https://docs.aws.amazon.com/quicksight/latest/user/data-source-limits.html
Additionally, I would recommended the below workaround to avoid this:
The following are steps that you can take to limit the amount of data that you're importing into Quicksight:
-
Unselect columns that you don't need.
-
Add filters to your data set in Quicksight.
-
Use predicates in your custom SQL query such as WHERE and HAVING.
[+] - https://repost.aws/knowledge-center/quicksight-resolve-query-timeout-issues
That being said, to further look into this issue more closely, if you would like to do a resource based troubleshooting, please raise a support case with AWS for further information. If a support case has already been created please be assured that we will get back to you and assist you in the best way possible.
相關內容
- AWS 官方已更新 1 年前
- AWS 官方已更新 1 年前
But we have 10 TB of data in S3 , and for internal business data visual query we want to use presto as a cluster to scan the data from s3 as time is actually not the concern for the users to get the output.
Quicksight is a reporting platform from where users are expected to add new filter conditions and presto will fire the query on those filters. currently the scan of 10 TB Data usually takes more than 5 min for each of these queries , Quicksight doesnt seem to be the right option then ? As to again the store the 10TB of data in SPICE will actually add on to the costs which we are trying to save .
Please suggest a workaround where data storage is expected to be S3 and queries can take more than 5 min to be displayed in quicksight visuals.