bqr_auth {bigQueryR}R Documentation

Authenticate this session


Autheticate manually via email or service JSON file


bqr_auth(json_file = NULL, token = NULL,
  email = Sys.getenv("GARGLE_EMAIL"))



Authentication json file you have downloaded from your Google Project


A preexisting token to authenticate with


A Google email to authenticate with

If you have set the environment variable BQ_AUTH_FILE to a valid file location, the function will look there for authentication details. Otherwise it will trigger an authentication flow via Google login screen in your browser based on the email you provide.

If BQ_AUTH_FILE is specified, then authentication will be called upon loading the package via library(bigQueryR), meaning that calling this function yourself at the start of the session won't be necessary.

BQ_AUTH_FILE is a GCP service account JSON ending with file extension .json


Invisibly, the token that has been saved to the session


## Not run: 

# to use default package credentials (for testing)

# or via email

# 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")
# should now be able to log in via your own GCP project

# reauthentication
# Once you have authenticated, set email to skip the interactive message
bqr_auth(email = "")

# or leave unset to bring up menu on which email to auth with
# 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.
# you can set authentication for many emails, then switch between them e.g.
bqr_auth(email = "")
bqr_list_projects() # lists what GCP projects you have access to
bqr_auth(email = "") 
bqr_list_projects() # lists second set of projects

## End(Not run)

[Package bigQueryR version 0.5.0 Index]