phc_tbl: Create a tbl pointer to a specified schema and table in the...

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

Description

Note: requires a connection using a Snowflake role such as PHC_ANALYTICS If a schema name is not provided, will print a list of the available schemas in PHC_DB_DEV. If a table name is not provided, will print a list of the available tables in the specified schema.

Usage

phc_tbl(conn, schema = NA, name = NA)

Arguments

conn	a DBI-compliant connection object. recommend using the 'connect_cdw()' function
schema	A character string specifying a table
name	A character string specifying a table or view

Value

a tbl or a display of tables and views available

Examples

## Not run: 
# must use a role that has access (ie. PHC_ANALYTICS)
conn <- connect_cdw(role = "PHC_ANALTYICS")

phc_tbl(conn)

phc_tbl(conn, schema = "REF")

phc_tbl(conn, "WHS_SEPSIS_DATAMART", "SEPSIS")

disconnect_cdw(conn)

## End(Not run)

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