Achilles (version 1.6.3)

dropAllScratchTables: Drop all possible scratch tables

Description

Drop all possible scratch tables

Usage

dropAllScratchTables(connectionDetails, scratchDatabaseSchema,
  tempAchillesPrefix = "tmpach", tempHeelPrefix = "tmpheel",
  numThreads = 1, tableTypes = c("achilles", "heel",
  "concept_hierarchy"), outputFolder, verboseMode = TRUE)

Arguments

connectionDetails

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

scratchDatabaseSchema

string name of database schema that Achilles scratch tables were written to.

tempAchillesPrefix

The prefix to use for the "temporary" (but actually permanent) Achilles analyses tables. Default is "tmpach"

tempHeelPrefix

The prefix to use for the "temporary" (but actually permanent) Heel tables. Default is "tmpheel"

numThreads

The number of threads to use to run this function. Default is 1 thread.

tableTypes

The types of Achilles scratch tables to drop: achilles or heel or concept_hierarchy or all 3

outputFolder

Path to store logs and SQL files

verboseMode

Boolean to determine if the console will show all execution steps. Default = TRUE

Details

Drop all possible Achilles, Heel, and Concept Hierarchy scratch tables