Create the concept hierarchy
createConceptHierarchy(connectionDetails, resultsDatabaseSchema,
scratchDatabaseSchema, vocabDatabaseSchema, outputFolder,
numThreads = 1, tempAchillesPrefix = "tmpach", sqlOnly = FALSE,
verboseMode = TRUE)An R object of type connectionDetails created using the function createConnectionDetails in the DatabaseConnector package.
Fully qualified name of database schema that we can write final results to. Default is cdmDatabaseSchema. On SQL Server, this should specifiy both the database and the schema, so for example, on SQL Server, 'cdm_results.dbo'.
Fully qualified name of the database schema that will store all of the intermediate scratch tables, so for example, on SQL Server, 'cdm_scratch.dbo'. Must be accessible to/from the cdmDatabaseSchema and the resultsDatabaseSchema. Default is resultsDatabaseSchema. Making this "#" will run Achilles in single-threaded mode and use temporary tables instead of permanent tables.
String name of database schema that contains OMOP Vocabulary. Default is cdmDatabaseSchema. On SQL Server, this should specifiy both the database and the schema, so for example 'results.dbo'.
Path to store logs and SQL files
(OPTIONAL, multi-threaded mode) The number of threads to use to run Achilles in parallel. Default is 1 thread.
(OPTIONAL, multi-threaded mode) The prefix to use for the scratch Achilles analyses tables. Default is "tmpach"
TRUE = just generate SQL files, don't actually run, FALSE = run Achilles
Boolean to determine if the console will show all execution steps. Default = TRUE
Post-processing, create the concept hierarchy. Please note: this table creation only requires the Vocabulary, not the CDM itself. You could run this once for 1 Vocab version, and then copy the table to all CDMs using that Vocab.