looker-open-source / henry

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

Analyzing explores shows 151 joins #22

Open moseleyi opened 4 years ago

moseleyi commented 4 years ago

We do have two views that are joined to almost every other view and I am wondering if that's causing output like this:

+---------+--------------------------------+-------------+-------------------+-----------+------------------+------------+-------------------+---------------+
| Model   | Explore                        | Is Hidden   | Has Description   |  # Joins  |  # Unused Joins  |  # Fields  |  # Unused Fields  |  Query Count  |
|---------+--------------------------------+-------------+-------------------+-----------+------------------+------------+-------------------+---------------|
| model   | epr_explor                     | False       | False             |    151    |        0         |    488     |        181        |     7938      |

It could be a problem with our overall design but I think Henry could help me identify this, wouldn't that be grand : )

Thinking whether it's possible to show the output when analysing particular explore and some kind of joins tree