Question

Get list of filters across dashboards/looks (API)

  • 20 May 2021
  • 0 replies
  • 42 views

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:

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. 


This topic has been closed for comments