SQL Only Mode

In most Achilles functions, you can specify sqlOnly = TRUE in order to produce the SQL without executing it, which can be useful if you’d like to examine the SQL closely or debug something. The SQL files are stored in the outputFolder.

Logging

File and console logging is enabled across most Achilles functions. The status of each step is logged into files in the outputFolder. You can review the files in a common text editor.

Verbose Mode

The verboseMode parameter can be set to FALSE if you’d like less details about the function execution to appear in the console. Either way, all details are written to the log files. By default, this is set to TRUE.

Preparation for running Achilles

In order to run the package, you will need to determine if you’d like the Achilles tables and staging tables to be stored in schemas that are separate from your CDM’s schema (recommended), or within the same schema as the CDM.

Staging Table Prefix

To keep the staging tables organized, the achilles function will use a table prefix of “tmpach” by default, but you can choose a different one using the tempAchillesPrefix parameter. This is useful for database platforms like Oracle, which limit the length of table names.

Source Name

The sourceName parameter is used to assign the name of the dataset to the Achilles results. If you set this to NULL, the achilles function will try to obtain the source name from the CDM_SOURCE table.

Create Table

The createTable parameter, when set to TRUE, drops any existing Achilles results tables and builds new ones. If set to FALSE, these tables will persist, and the achilles function will just insert new data to them.

Limiting the Analyses

By default, the achilles function runs all default analyses detailed in the getAnalysisDetails function. However, it may be useful to focus on a subset of analyses rather than running the whole set. This can be accomplished by specifying analysis Ids in the analysisIds parameter.

Cost Analyses

By default, the achilles function does not run analyses on the COST table(s), as they can be very time-consuming, and are not critical to most OHDSI studies. However, you can choose to run these analyses by setting runCostAnalysis to TRUE. The cost analyses are conditional on the CDM version. If using CDM v5.0, then the older cost tables are queried. If using any version after 5.0, the unified cost table is queried.

Small Cell Count

To avoid patient identification, you can establish the minimum cell size that should be kept in the Achilles tables. Cells with small counts (less than or equal to the value of the smallCellCount parameter) are deleted. By default, this is set to 5. Set to 0 for complete summary without small cell count restrictions.

Drop Scratch Tables

See the Post-Processing section to read about how to run this step separately

This parameter is only necessary if running in multi-threaded mode

The dropScratchTables parameter, if set to TRUE, will drop all staging tables created during the execution of achilles in multi-threaded mode.

Create Indices

See the Post-Processing section to read about how to run this step separately

The createIndices parameter, if set to TRUE, will result in indices on the Achilles results tables to be created in order to improve query performance.

Return Value

When running achilles, the return value, if you assign a variable to the function call, is a list object in which metadata about the execution and all of the SQL scripts executed are attributes. You can also run the function call without assigning a variable to it, so that no values are printed or returned.

Creating Indices

Not supported by Amazon Redshift or IBM Netezza; function will skip this step if using those platforms

To improve query performance of the Achilles results tables, run the createIndices function.

connectionDetails <- createConnectionDetails(dbms = "postgresql", 
                                             server = "localhost/synpuf", 
                                             user = "cdm_user", 
                                             password = "cdm_password")

createIndices(connectionDetails = connectionDetails, 
              resultsDatabaseSchema = "results", 
              outputFolder = "output")

Dropping All Staging Tables (Multi-threaded only)

If the achilles execution has errors, or if you did not enable this step in the call to these functions, use the dropAllScratchTables function.

The tableTypes parameter can be used to specify which batch of staging tables to drop (“achilles”).

connectionDetails <- createConnectionDetails(dbms = "postgresql", 
                                             server = "localhost/synpuf", 
                                             user = "cdm_user", 
                                             password = "cdm_password")

dropAllScratchTables(connectionDetails = connectionDetails, 
                     scratchDatabaseSchema = "scratch", numThreads = 5)