cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Refresh Dashboard also make all related queried refresh?

Anonymous
Not applicable

Hi all,

I have a quick currious. I know both query and dashboard page in Databricks SQL have refresh button to can them refresh. But one question it, when I'm in Dashboard page and click the refesh button. Does this thing also force every related queries in refresh?

Thank you all very much and have a nice day? ๐Ÿ˜‰

BR,

Jensen

1 ACCEPTED SOLUTION

Accepted Solutions

Unforgiven
Valued Contributor III

@Jensen Acklesโ€‹  Here is answer your concern. that is i found on doc databrick as link below :

https://docs.databricks.com/sql/user/dashboards/index.html#refresh-a-dashboard

Hope this can help on this case

Refresh a dashboard

Dashboards should load quickly because they fetch their data from a cache that renews whenever a query runs. But if you havenโ€™t run the queries recently, your dashboard might be stale. It could even mix old data with new if some queries ran more recently than others. Verify when your visualizations were last refreshed.

Each time a dashboard is refreshed, either manually or on a schedule, all queries in the dashboard and all upstream queries, including those used by parameters, are refreshed. When an individual visualization is refreshed, all upstream queries, including those used by parameters, are refreshed.

Manually refresh a dashboard

To force a refresh, click Refresh on the top right of the dashboard. This runs all the dashboard queries and updates its visualizations.

Cheer

View solution in original post

3 REPLIES 3

Unforgiven
Valued Contributor III

@Jensen Acklesโ€‹  Here is answer your concern. that is i found on doc databrick as link below :

https://docs.databricks.com/sql/user/dashboards/index.html#refresh-a-dashboard

Hope this can help on this case

Refresh a dashboard

Dashboards should load quickly because they fetch their data from a cache that renews whenever a query runs. But if you havenโ€™t run the queries recently, your dashboard might be stale. It could even mix old data with new if some queries ran more recently than others. Verify when your visualizations were last refreshed.

Each time a dashboard is refreshed, either manually or on a schedule, all queries in the dashboard and all upstream queries, including those used by parameters, are refreshed. When an individual visualization is refreshed, all upstream queries, including those used by parameters, are refreshed.

Manually refresh a dashboard

To force a refresh, click Refresh on the top right of the dashboard. This runs all the dashboard queries and updates its visualizations.

Cheer

Ajay-Pandey
Esteemed Contributor III

Dashboards should load quickly because they fetch their data from a cache that renews whenever a query runs. But if you havenโ€™t run the queries recently, your dashboard might be stale. It could even mix old data with new if some queries ran more recently than others. Verify when your visualizations were last refreshed.

Each time a dashboard is refreshed, either manually or on a schedule, all queries in the dashboard and all upstream queries, including those used by parameters, are refreshed. When an individual visualization is refreshed, all upstream queries, including those used by parameters, are refreshed.

Ajay Kumar Pandey

Anonymous
Not applicable

Thanks all your support. It's totally clear for me now!!!

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