Getting Databricks SQL dashboard to recognise change to an underlying query
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2023 04:02 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2023 05:55 AM
Can you take a screenshot ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2023 07:20 AM
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
![](/skins/images/B38AF44D4BD6CE643D2A527BE673CCF6/responsive_peak/images/icon_anonymous_message.png)
![](/skins/images/B38AF44D4BD6CE643D2A527BE673CCF6/responsive_peak/images/icon_anonymous_message.png)