was wondering if anyone else has had this error. ...
# troubleshooting
c
was wondering if anyone else has had this error. I'm new to the tool, and trying to setup a postgres tap with a gbq target. pg tap installs just fine, but the
meltano add loader target-bigquery
returns:
Copy code
Loader 'target-bigquery' could not be installed: failed to install plugin 'target-bigquery'.
  Running command git clone --filter=blob:none -q <https://github.com/adswerve/target-bigquery.git> /private/var/folders/w4/qkk0hzgd7h59kkrlkxr9ly380000gq/T/pip-req-build-qi2be3sa
  WARNING: Did not find branch or tag 'v0.11.3', assuming revision or ref.
  Running command git checkout -q v0.11.3
  error: pathspec 'v0.11.3' did not match any file(s) known to git
WARNING: Discarding git+<https://github.com/adswerve/target-bigquery.git@v0.11.3>. Command errored out with exit status 1: git checkout -q v0.11.3 Check the logs for full command output.
ERROR: Command errored out with exit status 1: git checkout -q v0.11.3 Check the logs for full command output.

Failed to install plugin(s)
I see in the repo that the 0.11.3 tag exists. Anyone else run into this?
n
Yes, I ran into the same issue yesterday. I parked that approach for now, and am using json files as my loader to go into BQ for now 🤓
e
Hey @chris_stout @nigel_vining, thanks for reporting! Can you try adding a custom
pip_url
to the plugin in
meltano.yml
?
Copy code
plugins:
  loaders:
    - name: target-bigquery
      pip_url: git+<https://github.com/adswerve/target-bigquery.git@0.11.3>
I think the right tag is
0.11.3
(the target devs changed their mind with tag convention
v0.10.2 -> 0.11.3
).
Let me know if that fixes the problem 😄
n
Thanks Edgar, i’ll let you know tomorrow my time, just finished up for the day 🙂
c
Ah, good eye! I didn't catch that. Looked like it worked. I'll keep going and see how it goes. Thanks so much for unblocking me @edgar_ramirez_mondragon
e
@chris_stout Glad it worked!
c
I'm getting close, but running into some problems, not sure if you or Nigel had to do any sort of different GBQ auth. The docs I read have you creating a service account and creating a key, but I'm not going to have the ability to create keys. I can auth into google on the cli with gcloud auth login, but that's about it.
n
Yes, you need a service account keyfile. It can’t be run as a standard user/password account as that would require a call out to get an oauth token etc ….
c
That's right - was thinking kind of how dbt enabled oauth with bigquery like that