createObservationTable: Run the query to create the observation table.

Description Usage Arguments

Description

This function will call and run the sql file to create the observation table from the STEM table. Requires that the function chunkData is run first.

Usage

1
2
createObservationTable(connectionDetails, cdmDatabaseSchema,
  oracleTempSchema = NULL)

Arguments

connectionDetails

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

cdmDatabaseSchema

The name of the database schema that contains the OMOP CDM instance. Requires read permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'cdm_instance.dbo'.

oracleTempSchema

For Oracle only: the name of the database schema where you want all temporary tables to be managed. Requires create/insert permissions to this database.


OHDSI/ETL-HealthVerityBuilder documentation built on May 19, 2019, 12:40 a.m.