library("allofus")
<- aou_connect()
con # reference the observation table in the database
::tbl(con, "observation")
dplyr# print a list of the tables in the database
::dbListTables(con) DBI
Create a connection to the database in All of Us
Description
Connects to the All of Us database and returns a BigQueryConnection object. You can reference this object to query the database using R and or SQL code. A message is printed with the connection status (successful or not).
Usage
aou_connect(CDR = getOption("aou.default.cdr"), ...)
Arguments
CDR
|
The name of the "curated data repository" to connect to. Defaults to getOption(“aou.default.cdr”) , which is Sys.getenv(‘WORKSPACE_CDR’) if not specified otherwise (i.e., the "mainline" CDR). On the controlled tier, specify the "base" CDR with CDR = paste0(Sys.getenv(‘WORKSPACE_CDR’), “_base”) .
|
…
|
Further arguments passed along to DBI::dbConnect() .
|
Details
You can reference this object to connect to the All of Us database and run SQL code using, e.g., dbplyr
or DBI
. A message is printed with the connection status (successful or not).
Value
A BigQueryConnection
object. This object is also saved as an option (getOption(“aou.default.con”)
).