fetch_db: Fetch data from db

Description Usage Arguments Value

View source: R/fetch_db.R

Description

Fetch data from db

Usage

1
2
fetch_db(conn = NULL, path = NULL, query = NULL, async = FALSE,
  dsn = NULL, ...)

Arguments

conn

A database connection. Only necessary if 'async = FALSE'.

path

A SQL file path. Optionally, use 'query'.

query

A SQL string. Optionally, use 'path'. If both are supplied, 'path“ is used.

async

A logical indicating whether to execute the query asynchronously or (default) not.

dsn

The Data Source Name.

...

Named values to interpolate into the query string.

Value

If processed in a synchronous manner (the default), a data frame with as many rows as records and as many columns as fields in the result set. If processed in an asynchronous manner, a Future. To get the value of a future, use future::value. In case of error, a print of the full SQL error is returned before execution of error action.


quartin/dbutils documentation built on Dec. 8, 2018, 2:18 a.m.