connect_cdw: Set up a connection to Snowflake (CDW)

In RollieParrish/ccdm: R functions for the Core Clinical Data Model (CCDM)

Description

Set up a connection to Snowflake (CDW)

Usage

connect_cdw(
  database = "HI_DB",
  schema = "WHS_SYNERGY",
  role = "REGIONAL_ANALYTICS_RO",
  warehouse = "REGIONAL_ANALYTICS_WH"
)

Arguments

database	a valid database that the specified role can access. Default is PHC_DB_DEV
schema	a valid schema that the specified role can access. Default is WHS_CORE_CDM
role	a valid role that you can use. Default is PHC_ANALYTICS. Roles typically have default databases and warehouses.
warehouse	a valid warehouse that the specified role can access. Default is PHC_ANALYTICS_WH_S.

Examples

## Not run: 
conn <- connect_cdw()

ccdm_tbl(conn)

ccdm_tbl(conn, "HOSPITAL_ENCOUNTERS")

ccdm_tbl(conn, role = "REGIONAL_ANALYTICS")

disconnect_cdw(conn)

## End(Not run)

RollieParrish/ccdm documentation built on Dec. 31, 2020, 4:26 p.m.