Getting Databricks SQL dashboard to recognise change to an underlying query

labromb
Databricks Partner

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