cdata (version 1.0.7)

qlook: Quick look at remote data

Description

Quick look at remote data

Usage

qlook(my_db, tableName, displayRows = 10, countRows = TRUE)

Arguments

my_db

database handle

tableName

name of table to look at

displayRows

number of rows to sample

countRows

logical, if TRUE return row count.

Value

str view of data

Examples

Run this code
# NOT RUN {
if ( requireNamespace("DBI", quietly = TRUE) &&
  requireNamespace("RSQLite", quietly = TRUE)) {
  my_db <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
  rquery::rq_copy_to(my_db,
                    'd',
                    data.frame(AUC = 0.6, R2 = 0.2),
                    overwrite = TRUE,
                    temporary = TRUE)
  qlook(my_db, 'd')
  DBI::dbDisconnect(my_db)
}

# }

Run the code above in your browser using DataCamp Workspace