LoadVocabFromCsv: Load Vocabulary Tables From CSV Files.

In OHDSI/ETL-Synthea: A Builder for Converting the Synthea Data to the OMOP CDM

Load Vocabulary Tables From CSV Files.

Description

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

Usage

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.

OHDSI/ETL-Synthea documentation built on Feb. 24, 2025, 3:48 a.m.