OHDSI Home | Forums | Wiki | Github

Achilles and BigQuery

Is anyone who has been able to get Achilles to run using BigQuery willing to share some about how they set things up? I’ve tried following the documentation for creating a connection but I can’t seem to get it to open properly.

1 Like
library(Achilles)

connectionDetails <- createConnectionDetails(
  dbms="bigquery", 
  connectionString="jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=YOUR_PROJECT_ID;OAuthType=0;OAuthServiceAcctEmail=bigquery-admin@atlas-iap.iam.gserviceaccount.com;OAuthPvtKeyPath=C:/bigquery-admin-service-acc-key.json;Timeout=1000",
  user="",
  password='',
  pathToDriver = "PATH_TO_FOLDER_WITH_BQ_SIMBA_DRIVERS"
)

achilles(connectionDetails, 
         cdmDatabaseSchema = "synpuf_110k", 
         resultsDatabaseSchema = "synpuf_110k_results",
         scratchDatabaseSchema = "synpuf_110k_results",
         vocabDatabaseSchema = "synpuf_110k",
         numThreads = 2,
         sourceName = "BigQuery", 
         cdmVersion = "5.3.0",
         runHeel = TRUE,
         runCostAnalysis = TRUE,
         conceptHierarchy = TRUE
)
1 Like
t