looker-open-source / henry

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

Can I use Henry with an old self-hosted Looker instance (v5.24) #36

Closed iamaziz closed 3 years ago

iamaziz commented 3 years ago

Hi there,

Sorry for having to open an issue just to ask this question. I spent some time trying to get Henry to work with an old self-hosted Looker instance (Looker v5.24) with no luck so far. Also, the instance is running behind a VPN network.

It seems to fail mostly due to some connections issues. Here's an example error from henry pulse command:

(.env) $ henry pulse 
RUNNING (1/5) Testing Connections:   0% |                                                 |[00:00<?]

RUNNING (2/5) Analyzing Query Stats:   0% |                                               |[00:00<?]Error: 404 Client Error: Not Found for url: https://<INSTANCE-URL>:443/api/3.0/queries/run/json?cache=false
RUNNING (2/5) Analyzing Query Stats:   0% |                                               |[00:00<?]
Traceback (most recent call last):
  File ".../.env/bin/henry", line 8, in <module>
    sys.exit(main())
  File ".../.env/lib/python3.8/site-packages/henry/cli.py", line 306, in main
    result = pulse.run_all()
  File ".../.env/lib/python3.8/site-packages/henry/commands/pulse.py", line 33, in run_all
    r1, r2, r3 = self.check_query_stats()
  File ".../.env/lib/python3.8/site-packages/henry/commands/pulse.py", line 123, in check_query_stats
    query_count = self.get_query_type_count()
  File ".../.env/lib/python3.8/site-packages/henry/commands/pulse.py", line 211, in get_query_type_count
    if(len(r) > 0):
TypeError: object of type 'NoneType' has no len()

Before I spend more time debugging this, I would love to verify if Henry supports older versions of Looker? Thanks.

UPDATE:

I tried hitting that endpoint URL https://<LOOKER-INSTANCE>:443/api/3.0/queries/run/json using the same API keys that I set up in Henry, but I get this 404 response:

{
    "message": "Not found",
    "documentation_url": "http://docs.looker.com/"
}
iamaziz commented 3 years ago

The answer is yes, it turns out the above problem is due to the access-level of the API keys I am using. Now, fixed.

Closing this issue.