CODEWITHSUNDEEP
rrstudiogoogle-bigquerydplyr
Lawrence
Lawrence

Reputation: 277

Rstudio session aborted after allowing R Bigquery to view/manage my data in google bigquery

I am trying to connect R to Bigquery using bigrquery package and dplyr. Below is the sample code:

library(bigrquery)
project <- "fantastic-voyage-389" # put your project ID here
sql <- "SELECT year, month, day, weight_pounds FROM    [publicdata:samples.natality] LIMIT 5"
query_exec(sql, project = project)

R asks me to cache OAuth between sessions, and it brings me to the browser session where it asks me the permission for view and manage my data in bigquery. Once I clicked yes, the browser says 'authentication completed'. In the meantime, however, the Rstudio crashs and says R has a fatal error.

my bigrquery package version is 0.1.0, and Rstudio 0.99.486

Does anyone have same experience before?

Upvotes: 2

Views: 452

Answers (1)

Nick
Nick

Reputation: 3591

The solution was to delete tokens cached on disk by the httr library's OAuth2.0 functionality.

If this issue continues to occur (ie. reset_access_cred() doesn't work), a manual fix like this is clearly undesirable, and an issue should be opened with the maintainers of httr or bigrquery, depending on what's likely at fault.

Upvotes: 1

Related Questions