Insert a population into a database
insertDbPopulation( population, cohortIds = c(1, 0), connectionDetails, cohortDatabaseSchema, cohortTable = "cohort", createTable = FALSE, dropTableIfExists = TRUE, cdmVersion = "5" )
population | Either an object of type CohortMethodData or a population
object generated by functions like |
---|---|
cohortIds | The IDs to be used for the target and comparator cohort, respectively. |
connectionDetails | An R object of type |
cohortDatabaseSchema | The name of the database schema where the data will be written. Requires write permissions to this database. On SQL Server, this should specify both the database and the schema, so for example 'cdm_instance.dbo'. |
cohortTable | The name of the table in the database schema where the data will be written. |
createTable | Should a new table be created? If not, the data will be inserted into an existing table. |
dropTableIfExists | If |
cdmVersion | Define the OMOP CDM version used: currently supports "5". |
Inserts a population table into a database. The table in the database will have the same structure as the COHORT table in the Common Data Model.