patrickhulce / third-party-web

Data on third party entities and their impact on the web.
https://www.thirdpartyweb.today/
MIT License
1.07k stars 101 forks source link

Invalid grant / bigquery gcloud auth #227

Closed paulirish closed 1 week ago

paulirish commented 1 month ago

I'm trying to get authenticated to update the bigquery but running into some challenges.

Readme indicates using gcp-credentials but that filename isn't supported anymore. But.. even then.. I'm not sure this approach is preferred.

@Nigui @kporal what approach did yall use most recently?

I'm getting the farthest by creating a new KEY with my service account.. downloading that json. then

GOOGLE_APPLICATION_CREDENTIALS=thatseviceaccountkeyfile.json  node bin/automated-update.js

But still facing some permission challenges. I want to figure out the supported path so we can update the documentation.

patrickhulce commented 1 month ago

Thanks Paul :)

The GOOGLE_APPLICATION_CREDENTIALS path you've noted should work. We don't do anything fancy here with auth, just invoke the GCloud SDK which looks for default creds.

What permissions errors are you getting? Authentication? Query authorization? Write authorization?

paulirish commented 1 month ago

Was getting invalid grant. mostly fixed with the env variable as i noted.. now i'm at

image

this seems to be related to #224

patrickhulce commented 1 month ago

Ah, I haven't fully run through with #224 yet, could have broken the pipeline :/

Nigui commented 3 weeks ago

Hello, sorry for the late answer. Did you found a fix for this "empty schema" issue yet? If not, I'll have a look and come back with it. Sorry again for that break.

paulirish commented 3 weeks ago

Did you found a fix for this "empty schema" issue yet?

I haven't found a fix no. I was running with the original lighthouse-infrastructure GCP project fwiw.

Sorry again for that break.

All good. :)

github-actions[bot] commented 1 week ago

:tada: This issue has been resolved in version 0.25.0 :tada:

The release is available on:

Your semantic-release bot :package::rocket: