How to avoid query caching in live data models

[ihoryokhym]

How to avoid query caching in live data models

Step-by-Step Guide: 

Understanding the Effects of Caching:

1. When data is updated with SQL statements (e.g., updates in Snowflake), Sisense's query caching might not immediately reflect these updates.
2. Widget refreshes might still show the cached data instead of the latest updates.

Adjusting Live Model Query Settings:

1. You can manage caching behavior by adjusting the LiveResultsCacheSize and LiveResultsCacheTimeout parameters.
2. Access Configuration Manager:
1. Navigate to the 'Admin' tab.
2. Go to 'Server & Hardware' settings.
3. Configure 'Query Service' settings by clicking the Sisense logo five times.
   
   
3. Modify Query Service Parameters:
1. Locate and adjust the LiveResultsCacheSize and LiveResultsCacheTimeout values. Setting a smaller value can reduce the caching duration.
2. Save the changes.

Using Automatic Refresh:

1. Enable 'Automatic Refresh' under Live Model Query Settings:
1. This setting allows dashboards to refresh automatically at intervals specified by the Refresh Rate.
2. Note: A minimal refresh rate can be set to 2 seconds.
2. Considerations:
1. Frequent automatic refresh may lead to increased query costs.

Force Fresh Queries:

1. Unfortunately, Sisense does not support bypassing the live model query cache entirely.
2. While automatic refresh or adjusting cache settings can help, forcing a fresh query every time is not feasible within current configurations.