Create a tbl pointer to Canoodle.

If a name is not provided, will print a list of the available views in MY_DB.STG_CANOODLE.

Usage

canoodle_tbl(conn, name = NA)

Arguments

conn

a DBI-compliant connection object. recommend using the 'connect_cdw()` function

name

A character string specifying a table in the MY_DB.STG_CANOODLE schema

Value

a tbl or a display of tables and views in the STG_CANOODLE schema

Examples

if (FALSE) { # \dontrun{
conn <- connect_cdw()

canoodle_tbl(conn)

canoodle_tbl(conn, "ICU_STAY_DATAMART")

disconnect_cdw(conn)
} # }