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: 

Getting Databricks SQL dashboard to recognise change to an underlying query

labromb
Contributor

Hi Community

Scenario:

I have created a query in Databricks SQL, built a number of visualisations from it and published them to a dashboard.

I then realise that I need to add another field to the underlying query that I want to then leverage as a dashboard filter.

The problem I have is the new field is not available to the filter dialogue when I specify the query containing the new field.

The only way I have been able to achieve is to delete the visualisations from the dashboard and then re-add them. Is there a better / more efficient way of doing this I am missing?

All thoughts / suggestions greatly appreciated

2 REPLIES 2

youssefmrini
Honored Contributor III

Can you take a screenshot ?

Yep sure

Query 1 (screenshot of which for some reason at the bottom of the reply, whereas other images have inserted in-line) is a simple query which I built a bar chart from and added bar chart to a dashboard.

If I then add a filter the dialog (correctly) displays the two available fields from the query Filter Dialog 1I then add a further field to the query, save it, run it etc.

Query 2I then go back to the dashboard, refresh and attempt to add the filter again, same two fields are available to base a filter on, but not the newly added fy field

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