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: 

Schedule a Notebook Dashboard

ehpogue
New Contributor II

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`?

2 REPLIES 2

Kaniz_Fatma
Community Manager
Community Manager

Hi @ehpogue , 

Certainly! Let’s explore some options to update your dashboard without manual intervention automatically:

  1. Scheduled Notebook Jobs:

    • In Databricks, you can create scheduled notebook jobs that run periodically. These jobs execute the notebook and can be used to refresh the data linked to your dashboard.
    • To set up a scheduled job:
    • By scheduling the notebook, you ensure the dashboard reflects the most current data without manual intervention.
  2. Dashboard Based on Job Run Results:

    • While sharing dashboards, consider using the job run results. Here’s how:
      • Create a dashboard based on the visualizations in your notebook.
      • Schedule runs of the notebook (e.g., daily or hourly).
      • Add users to the job run notifications (only for successful runs).
      • Please provide them with an illustrated guide on accessing the dashboard view from the email notification.
      • The dashboard link will be something like /run/latestSuccess/dashboard/{dashboard_id}.
    • This approach allows you to share an updated dashboard with non-coder audiences.
  3. Real-Time Updating:

Remember to choose the approach that best fits your requirements and audience. Happy dashboarding! 📊🚀

ehpogue
New Contributor II

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.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!