How to Reset or Clear Quick Sight Cache

[Abhishek4]

Quick Sight Parameters when using Direct Query are not getting refreshed automatically and have to be refreshed manually by the users for all the Parameters which is not a good user experience and this feature request based on the previous QnA looks like to be open for quite a while.
One workaround we feel is resetting the Quick Sight Cache might help to reset the dashboard . Is there a way to reset the Quick Sight Cache like every 10-15 mins

[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

[Abhishek4]

Hello latt_andr,

Thank you for the response.
Redshift is our datasource and we have a connection using a service account.

I read the thread that you mentioned but unfortunately it does not tell about restting cache or the parameter refresh workaround

However as you mentioned, we tried to alter the setting in redshift to not to store the cache if coming from service account that is used for connection but somehow quicksight is still able to keep a cache somewhere

[Koushik_Muthanna]

@Abhishek4 ,

The filter controls are refreshed every 24 hours automatically [Refreshing data in Amazon QuickSight - Amazon QuickSight ] , there is no
mechanism today to reset it every 10-15 minutes.

I understand that it’s another additional step for end users to manually click refresh to get the latest set of values, on the other hand you can imagine if there are 1000 of datasets being used in direct query in QuickSight and dashboards have lots of filters, a 10 to 15 minute auto refresh would overload the backend the database with queries.

I will mark this as a feature request.

Kind regards,
Koushik

[Brett]

Hi @Abhishek4,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @Abhishek4,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!