createCharacterizationTables: Create the results tables to store characterization results...

In Characterization: Implement Descriptive Studies Using the Common Data Model

Create the results tables to store characterization results into a database

Description

This function executes a large set of SQL statements to create tables that can store results

Usage

createCharacterizationTables(
  connectionDetails,
  resultSchema,
  targetDialect = "postgresql",
  deleteExistingTables = TRUE,
  createTables = TRUE,
  tablePrefix = "c_",
  tempEmulationSchema = getOption("sqlRenderTempEmulationSchema")
)

Arguments

connectionDetails	The connectionDetails to a database created by using the function createConnectDetails in the DatabaseConnector package.
resultSchema	The name of the database schema that the result tables will be created.
targetDialect	The database management system being used
deleteExistingTables	If true any existing tables matching the Characterization result tables names will be deleted
createTables	If true the Characterization result tables will be created
tablePrefix	A string appended to the Characterization result tables
tempEmulationSchema	The temp schema used when the database management system is oracle

Details

This function can be used to create (or delete) Characterization result tables

Value

Returns NULL but creates the required tables into the specified database schema.

See Also

Other Database: createSqliteDatabase(), insertResultsToDatabase()

Examples

# create sqlite database
charResultDbCD <- createSqliteDatabase()

# create database results tables
createCharacterizationTables(
   connectionDetails = charResultDbCD,
   resultSchema = 'main'
 )

Characterization documentation built on April 4, 2025, 2:02 a.m.