Schedule a Notebook Dashboard

[ehpogue]

Hey all,

I have a workflow that updates a delta table, and then runs a notebook that generates a dashboard. I was hoping that by adding this second step that the dashboard would get updated to show the most current data, instead of the user needing to click the `Update` button. But it seems per this convo that when a notebook runs in workflow it is a copy of the actual notebook and not the notebook itself, so it doesn't update the widgets or the dashboard. 

Is there a way to schedule the notebook such that the dashboard will have current data without the need to click `Update`?

[ehpogue]

Hey,

So I tested out your #2 solution, which is the one for the current situation - where I have a dashboard built off of a notebook - and it's not what I'm looking for. That's the equivalent of sending a report. I'm looking to trigger the equivalent of pressing the `update` button in the UI in `presentation mode`. The reason is that it is an interactive notebook where the user can use widgets to change the viz in the dashboard. The user doesn't want to have to click the `update` button every time to get the updated data, wait for all the visualizations to update, and then be able to use the widgets.

[trevormccormick]

Yes this is horrible UX. Scheduled a notebook dashboard to refresh daily. The scheduled automation will run the job for the notebook, but the dashboard points to the old notebook table output. I realize this cell output probably has a new backend ID but there has to be a way for Databricks to have two IDs for this table if it is used in a dashboard. My dashboard takes 25 mins to run and the user is not going to wait for that

[trevormccormick]

@ehpogue at the end of the day I just used chatgpt to rewrite a bunch of python code into SQL and mash together all of the temporary views into one giant query. hacky but it did work