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:ย 

Databricks SQL dashboard refresh

noimeta
Contributor II

We have scheduled a dashboard to automatically refresh at some specific time.

However, some visualizations in the dashboard don't get refreshed at the scheduled time.

Checking the query logs, we found the source queries were properly executed, but the visualization didn't get updated.

Anyone knows how to resolve this issue?

1 ACCEPTED SOLUTION

Accepted Solutions

I created a new dashboard from scratch, and it's working properly now.

Anyway, the old one is still not working.

View solution in original post

3 REPLIES 3

Vivian_Wilfred
Honored Contributor

Hi @noi metaaphanonโ€‹ Are you following the correct approach to refresh the dashboard? If yes, are you making any changes to the dashboard parameters and expecting the dashboard visualization to update at refreshes?

The value that dashboard refresh uses is the default value of the parameter saved by the first query in the dashboard that uses it. Try setting the default value in the query and see if the visualizations are updating.

noimeta
Contributor II

Thank you for the answers.

I'm using Databricks SQL environment, not the Data Science & Engineering one. And, I scheduled the dashboard following this guideline: https://docs.databricks.com/sql/user/dashboards/index.html#automatically-refresh-a-dashboard

Also, the issue occurs on only one dashboard. The rest dashboards work fine.

I created a new dashboard from scratch, and it's working properly now.

Anyway, the old one is still not working.

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