preview_cdw: Run a preview query

In tarakc02/getcdw: Query the CADS Data Warehouse from R

Run a preview query

Description

Run a query but only return the first n rows of results. Useful for testing queries that might run slowly.

Usage

preview_cdw(
  query,
  n = 10,
  dsn = config("default_dsn"),
  uid = NULL,
  pwd = NULL,
  ...
)

Arguments

query	A SQL query. This can be either the text of the query, the name of a file that contains the query, or a valid connection that contains the text of the query.
n	The maximum number of rows to return
dsn	The name of the connection, as it appears in your tnsnames
uid	Your username (see details)
pwd	Your password (see details)
...	Other arguments passed on to dbSendQuery in package odbc

tarakc02/getcdw documentation built on April 2, 2022, 4:13 p.m.