cdwSQL: passes a SQL query from a separate .sql file to the CDW.

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

Description

Note - must be a single SQL clause. Queries with multiple clauses should use the TBD function instead, which relies on the snowsql CLI application.

Usage

cdwSQL(conn = conn, sql = NULL)

Arguments

conn	a DBI connection object such as connect_cdw()
sql	path to a .sql file

Value

data	Query results as a data frame
fields	field names
elapsed_seconds	elapsed system time to run the query
status_message	the number of records & variables in the results

Examples

## Not run: 

conn <- connect_cdw()

sql <- read_sql("path/to/some_file.sql")

cdwSQL(conn, sql)

disconnect_cdw(conn)


## End(Not run)

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