cancel
Showing results for 
Search instead for 
Did you mean: 
Knowledge Sharing Hub
Dive into a collaborative space where members like YOU can exchange knowledge, tips, and best practices. Join the conversation today and unlock a wealth of collective wisdom to enhance your experience and drive success.
cancel
Showing results for 
Search instead for 
Did you mean: 

Caching and data freshness

Ajay-Pandey
Esteemed Contributor III

Dashboards maintain a 24-hour result cache to optimize initial loading times, operating on a best-effort basis. This means that while the system always attempts to use historical query results linked to dashboard credentials to enhance performance, there are some cases where cached results cannot be created or maintained.

The following table explains how caching varies by dashboard status and credentials:

Dashboard type Caching type
 
Published dashboard with embedded credentialsShared cache. All viewers see the same results.
Draft dashboard or published dashboard without embedded credentialsPer user cache. Viewers see results based on their data permissions.

Dashboards automatically use cached query results if the underlying data remains unchanged after the last query or if the results were retrieved less than 24 hours ago. If stale results exist and parameters are applied to the dashboard, queries will rerun unless the same parameters were used in the past 24 hours. Similarly, applying filters to datasets exceeding 64,000 rows prompts queries to rerun unless the same filters were previously applied in the last 24 hours.

Ajay Kumar Pandey
1 REPLY 1

Rishabh_Tiwari
Databricks Employee
Databricks Employee

Thank you for providing this valuable update on caching and data freshness @Ajay-Pandey . It's great to see how these features are designed to optimize performance and ensure data accuracy. We appreciate your detailed explanation and your efforts to keep the community informed!

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group