Quick look at remote data

rstr(
  my_db,
  tableName,
  ...,
  displayRows = 10,
  countRows = TRUE,
  qualifiers = NULL
)

rlook(
  my_db,
  tableName,
  ...,
  displayRows = 10,
  countRows = TRUE,
  qualifiers = NULL
)

Arguments

my_db

database handle

tableName

name of table to look at

...

not used, force later arguments to bind by name

displayRows

number of rows to sample

countRows

logical, if TRUE return row count.

qualifiers

optional named ordered vector of strings carrying additional db hierarchy terms, such as schema.

Value

str view of data

Examples

if ( requireNamespace("DBI", quietly = TRUE) && requireNamespace("RSQLite", quietly = TRUE)) { my_db <- DBI::dbConnect(RSQLite::SQLite(), ":memory:") DBI::dbWriteTable(my_db, 'd', data.frame(AUC = 0.6, R2 = 0.2), overwrite = TRUE, temporary = TRUE) rlook(my_db, 'd') DBI::dbDisconnect(my_db) }
#> table `d` SQLiteConnection #> nrow: 1 #> 'data.frame': 1 obs. of 2 variables: #> $ AUC: num 0.6 #> $ R2 : num 0.2