search

looker-open-source / henry

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

error: 'access_token' not found #1

Closed emilywilson2 closed 5 years ago

emilywilson2 commented 5 years ago

when using the command 'henry pulse' i am getting the following error: ERROR: 'access_token' not found

josephaxisa commented 5 years ago

@emilywilson2 Hey Emily, can you show me the output of pip show henry please? I want to confirm that you are using the latest version.

emilywilson2 commented 5 years ago

Hi Joseph thanks for the reply, i was using version 9.0.1, just updated to 19.0.3, but get the same error

josephaxisa commented 5 years ago

@emilywilson2 I believe that's your pip version not henry's version. What does the command pip show henry output?

emilywilson2 commented 5 years ago

Name: henry Version: 0.1.1

emilywilson2 commented 5 years ago

fyi i am able to use henry (which is awesome btw) if i define host, client id and client secret every time i run a command

josephaxisa commented 5 years ago

Okay, perfect. As suspected, you are using a slightly older version. Run the command pip install --upgrade henry in order to get version 0.1.2. You can confirm this by running pip show henry afterwards.

Also, to avoid having to define the host, id and secret every time you run a command I would highly recommend using a credentials file. Please see the instructions here to do that: https://github.com/looker-open-source/henry/wiki/Getting-Started#credentials

emilywilson2 commented 5 years ago

Thanks for the help, one other question - is it possible to get a list of used fields as well as unused fields?

josephaxisa commented 5 years ago

Unfortunately no. You can obtain that information from the history explore in i__looker though.

Also, before removing any fields that are identified as unused by Henry please make sure they don't have any dependants. You could start by first commenting them out and then running the content validator to see if anything breaks.

emilywilson2 commented 5 years ago

When running a command, I'm still getting the error: Authentication Error: Check supplied credentials. My file is in the format:

hosts: looker: host: sphere.eu.looker.com id: ABCDEF.. secret: 1234567...

When the file is in the format suggested by the doc (see below), I get the error: ERROR: 'looker' not found

hosts: dev_looker: host: sphere.eu.looker.com id: ABCDEF secret: 1234567 staging_looker: host: sphere.eu.looker.com id: ABCDEF secret: 1234567

josephaxisa commented 5 years ago

@emilywilson2 the config file should look like this:

hosts:
  looker:
    host: sphere.eu.looker.com
    id: ABCDEF..
    secret: 1234567...

The indentation is very important.

Also, if your host alias is not looker, so for example, if you had

hosts:
  someOtherHost:
    host: sphere.eu.looker.com
    id: ABCDEF..
    secret: 1234567...

Then you would need to specify the host in your commands like so: henry pulse --host=someOtherHost because by default, the tool looks for the looker host. Which means that henry pulse is equivalent to henry pulse --host=looker.

Let me know if you solve this, otherwise I can jump on a quick call with you to get it sorted.

emilywilson2 commented 5 years ago

no worries joseph i just re-wrote the file and the problem seems to be fixed, so potentially was a syntax error. cheers for the help

emilywilson2 commented 5 years ago

One other question - we'd like to use the Looker API to remove a bulk of fields from a view file (we have 2000 unused fields in one explore), can you point me in the right direction for help with this?

josephaxisa commented 5 years ago

Hi again Emily, I highly recommend that you reach out to our support team with this request.

On Fri, Apr 12, 2019 at 2:56 PM emilywilson2 notifications@github.com wrote:

One other question - we'd like to use the Looker API to remove a bulk of fields from a view file, can you point me in the right direction for help with this?

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/looker-open-source/henry/issues/1#issuecomment-482584109, or mute the thread https://github.com/notifications/unsubscribe-auth/ASf8HtXLi6wL3upLHgK-K4XkH4ahHRBNks5vgJCdgaJpZM4cporH .