OHDSI Home | Forums | Wiki | Github

Achilles and BigQuery


(Will Carter) #1

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.


(Pavel Grafkin) #2
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
)

t