This function creates an empty cohort table and empty tables for cohort statistics.
createCohortTables(
connectionDetails = NULL,
connection = NULL,
cohortDatabaseSchema,
cohortTableNames = getCohortTableNames(),
incremental = FALSE
)
An object of type connectionDetails
as created using the
createConnectionDetails
function in the
DatabaseConnector package. Can be left NULL if connection
is
provided.
An object of type connection
as created using the
connect
function in the
DatabaseConnector package. Can be left NULL if connectionDetails
is provided, in which case a new connection will be opened at the start
of the function, and closed when the function finishes.
Schema name where your cohort tables reside. Note that for SQL Server, this should include both the database and schema name, for example 'scratch.dbo'.
The names of the cohort tables. See getCohortTableNames
for more details.
When set to TRUE, this function will check to see if the cohortTableNames exists in the cohortDatabaseSchema and if they exist, it will skip creating the tables.