topic Re: Databricks SQL dashboard refresh in Data Engineering

Databricks SQL dashboard refresh

noimeta — Mon, 07 Nov 2022 04:42:24 GMT

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?

Re: Databricks SQL dashboard refresh

Vivian_Wilfred — Tue, 08 Nov 2022 20:21:11 GMT

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.

Re: Databricks SQL dashboard refresh

noimeta — Wed, 09 Nov 2022 02:35:19 GMT

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.

Re: Databricks SQL dashboard refresh

noimeta — Tue, 15 Nov 2022 09:56:03 GMT

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

Anyway, the old one is still not working.