# NOT RUN {
# }
# NOT RUN {
# to use default package credentials (for testing)
library(bigQueryR)
bqr_auth("location_of_json_file.json")
# or via email
bqr_auth(email="me@work.com")
# to use your own Google Cloud Project credentials
# go to GCP console and download client credentials JSON
# ideally set this in .Renviron file, not here but just for demonstration
Sys.setenv("GAR_CLIENT_JSON" = "location/of/file.json")
library(bigQueryR)
# should now be able to log in via your own GCP project
bqr_auth()
# reauthentication
# Once you have authenticated, set email to skip the interactive message
bqr_auth(email = "my@email.com")
# or leave unset to bring up menu on which email to auth with
bqr_auth()
# The bigQueryR package is requesting access to your Google account.
# Select a pre-authorised account or enter '0' to obtain a new token.
# Press Esc/Ctrl + C to abort.
#1: my@email.com
#2: work@mybusiness.com
# you can set authentication for many emails, then switch between them e.g.
bqr_auth(email = "my@email.com")
bqr_list_projects() # lists what GCP projects you have access to
bqr_auth(email = "work@mybusiness.com")
bqr_list_projects() # lists second set of projects
# }
Run the code above in your browser using DataLab