CODEWITHSUNDEEP
rgoogle-bigquery
nFrain
nFrain

Reputation: 149

bigrquery throwing "Error: Invalid Credentials" when using query_exec()

I've been using the bigrquery library in r to run queries on my google big query project for the past 6 months. This morning I ran a simple query_exec() command that I've run a number of times over the past few days and I got the simple message "Error: Invalid Credentials".

I haven't been able to find documentation telling me how to fix this. I'm also not sure how to give code that will recreate the error.

The only thing that I can think of that changed is that I signed into a different gmail account.

Steps attempted so far:

  1. I logged out of the gmail account and logged back in to the right one.

  2. I uninstalled everything about R on my computer and reinstalled it all.

Still no luck.

I'm also realizing that there isn't a ton of information here. If there's something else I can provide that I haven't thought of I will be happy to answer questions.

Thanks for any help you can provide.

Upvotes: 3

Views: 881

Answers (1)

nFrain
nFrain

Reputation: 149

After more searching I found a way to clear your access credentials in this question and answer: BigRquery - RUN_QUERY_JOB

To summarize, if you force the access credentials to be null set_access_cred(NULL), then get new credentials get_access_cred(); you can re-authenticate.

Upvotes: 4

Related Questions