search

looker-open-source / henry

A command line tool for Looker instance cleanup
MIT License
79 stars 27 forks source link

identify used view.field_names in explore #3

Open jais0nd opened 5 years ago

jais0nd commented 5 years ago

Is it possible for Henry to identify used view.field_names in explores? This is very helpful to identify only the fields being used across explores and get rid of unwanted fields in views. Currently henry only provides unused view.field_names which is very messy since an unused view.field name under a particular explore doesn't mean that the field is unused by another explore.

This will be a super handy feature!

Thanks! Jai

josephaxisa commented 5 years ago

@jais0nd that's good feedback. It sounds like you want the ability to vacuum a view instead, correct? The reason it currently provides unused view.field_names is because it is meant to help you tidy up a given explore as opposed to going to the view to remove fields.

jais0nd commented 5 years ago

@josephaxisa - That's correct, we know most of our models and explores are used however we do not have the visibility on the field in views which are unused. In some cases there are views with over 200 fields. I want to get rid of the unused ones.