explore (version 0.8.0)

dwh_read_data: read data from DWH

Description

read data from DWH using a ODBC connection

Usage

dwh_read_data(connection, sql, names_lower = TRUE, ...)

Value

dataframe containing table data

Arguments

connection

DWH connection

sql

sql (character string)

names_lower

convert field names to lower (default = TRUE)

...

Further arguments to be passed to DBI::dbGetQuery()

Examples

if (FALSE) {
dwh_read_data(con, "select * from database.table_test")
}