Hi - I might be missing something obvious here, but thought I’d ask anyway!
Sometimes we need to update something about our underlying data that requires us to update filter values or remove filters across all or some dashboards/looks/merged queries.
It doesn’t seem like there’s a great way to get a list of all the places where a dimension/measure is used as a filter.
My goal, at a minimum, is to get a list of dashboards/looks/merged queries to check manually or plug into a function that will allow me to update/remove the targeted filter.
So far, I’ve looked at:
- looker_sdk (for python)
- Fivetran (article) has also written their own custom code (github) to do this (although, it’s not leveraging looker_sdk).
I’m wondering if there’s an easy-ish way to do this ,without going through some of the hoops Fivetran seems to go through, and leverage the API via looker_sdk.
Another thought I have is to leverage the Content Validator -- comment out the field I’m updating and get a list of all the errors. The error I get back is the “unknown field” error - which doesn’t help me distinguish where I need to update a filter exactly, but it is a starting point.
Let me know what you all think! Thanks.