topic Getting Databricks SQL dashboard to recognise change to an underlying query in Data Engineering

Getting Databricks SQL dashboard to recognise change to an underlying query

labromb — Fri, 14 Apr 2023 11:02:45 GMT

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

Re: Getting Databricks SQL dashboard to recognise change to an underlying query

youssefmrini — Fri, 14 Apr 2023 12:55:18 GMT

Can you take a screenshot ?

Re: Getting Databricks SQL dashboard to recognise change to an underlying query

labromb — Fri, 14 Apr 2023 14:20:46 GMT

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