search

looker-open-source / henry

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

Henry not aligning with i_looker results #2

Closed emilywilson2 closed 5 years ago

emilywilson2 commented 5 years ago

Hi I've been using Henry to identify unused fields in my LookML, but it isn't aligning with querying the same information in i_looker.

For example: Running henry vacuum explores --timeframe 90 --min_queries 5 --model big_query_model --explore user_stats pulls up the field user_stats.name as an unused field.

However, when querying on i_looker, filtering on the model = big_query_model, the explore = user_stats, and the timeframe = 90 days (as stated when using henry), it says user_stats.name has been used 11 times.

Could you explain why this might be?

josephaxisa commented 5 years ago

Hey @emilywilson2, I will look into this and get back to you.

emilywilson2 commented 5 years ago

Hi Joseph, unfortunately this issue is still persisting

josephaxisa commented 5 years ago

@emilywilson2 you need to first update henry, using pip install --upgrade henry. Please do that before running the command again.