How to Reset or Clear Quick Sight Cache

[lary_andr]

Hello @Abhishek4 , Hope this message finds you well!

In qs, parameters using Direct Query do not automatically refresh, requiring manual updates by users, which can lead to a suboptimal user experience. This issue has been noted in previous discussions and remains unresolved. A potential workaround is to reset the QuickSight cache periodically, which might help in refreshing the dashboard. However, QuickSight does not provide a built-in feature to automatically reset the cache at regular intervals, such as every 10-15 minutes. As a workaround, you could consider implementing a scheduled process outside of QuickSight to refresh the data source or trigger a cache reset, if supported by your data source, to ensure more frequent updates.

There’s some others discussion in the community that maybe help to understand better:

Is there a way to pass a parameter to alter the direct query?

I have a complex query to get the changes made to a customer’s account. In SQL I can write “select * from complex_query where customer_id = 123456” However, for tens of thousands of customers the query is very slow. One option is to make it a spice but there is limitation on refresh frequency( min is hourly) and doesn’t show the real time data . Is there a way to have a control of textbox of customer_ID and based on the Input the query is changed to “select * from complex_query where customer_…

please, tell me if it’s help you