Getting Databricks SQL dashboard to recognise change to an underlying query

[labromb]

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

[youssefmrini]

Can you take a screenshot ?

[labromb]

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 I then add a further field to the query, save it, run it etc.

I 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