Load Vocabulary Tables From CSV Files.

This function populates all Vocabulary tables with data in csv files.

LoadVocabFromCsv(
  connectionDetails,
  cdmSchema,
  vocabFileLoc,
  bulkLoad = FALSE,
  delimiter = "\t"
)

Arguments

connectionDetails

An R object of type
connectionDetails created using the function createConnectionDetails in the DatabaseConnector package.

cdmSchema

The name of the database schema that will contain the Vocabulary (and CDM) tables. Requires read and write permissions to this database. On SQL Server, this should specify both the database and the schema, so for example 'cdm_instance.dbo'.

vocabFileLoc

The location of the vocabulary csv files.

bulkLoad

Boolean flag indicating whether or not to use bulk loading (if possible). Default is FALSE.

delimiter

Parameter to specify the delimiter of the csv file. By default the function expects the file to be tab delimited ("\t") based on the export from Athena.

Details

This function assumes
createCDMTables() has already been run.