Insert a population into a database

insertDbPopulation(
  population,
  cohortIds = c(1, 0),
  connectionDetails,
  cohortDatabaseSchema,
  cohortTable = "cohort",
  createTable = FALSE,
  dropTableIfExists = TRUE,
  cdmVersion = "5"
)

Arguments

population

Either an object of type CohortMethodData or a population object generated by functions like createStudyPopulation().

cohortIds

The IDs to be used for the target and comparator cohort, respectively.

connectionDetails

An R object of type connectionDetails created using the DatabaseConnector::createConnectionDetails() function.

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 createTable = TRUE and the table already exists it will be overwritten.

cdmVersion

Define the OMOP CDM version used: currently supports "5".

Details

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.