This function will call and run the sql files to create the lookup tables. If parameter sqlFileList is left blank, the default will call LocationTable.sql, CareSiteTable.sql, PersonTable.sql and ProviderTable.sql
1 2 | createAllLookupTables(connectionDetails, cdmDatabaseSchema,
sourceDatabaseSchema, sqlFileList = NULL, oracleTempSchema = NULL)
|
connectionDetails |
An R object of type |
cdmDatabaseSchema |
The name of the database schema that contains the OMOP CDM instance. Requires read permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'cdm_instance.dbo'. |
sourceDatabaseSchema |
The name of the database schema that contains the raw data instance. Requires read permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'raw_instance.dbo'. |
sqlFileList |
The list of the sql files for the lookup tables containing the sql to run. For example list("LocationTable.sql","PersonTable.sql") |
oracleTempSchema |
For Oracle only: the name of the database schema where you want all temporary tables to be managed. Requires create/insert permissions to this database. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.