ca_prod_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

If a schema name is not provided, will print a list of the available schemas in CLINICAL_ANALYTICS_PROD. If a table name is not provided, will print a list of the available tables in the specified schema.

Usage

ca_prod_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: 
conn <- connect_cdw()

ca_prod_tbl(conn)

ca_prod_tbl(conn, schema = "DMS_ACUTE_CARE")

ca_prod_tbl(conn, "DMS_ACUTE_CARE", "SEPSIS")

disconnect_cdw(conn)

## End(Not run)

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