Quick look at remote data

Source: R/RowsColsQ.R

Quick look at remote data

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

Arguments

my_db

database handle
tableName

name of table to look at
...

force later arguments to be 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:")
  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)
}

#> table `d` SQLiteConnection 
#>  nrow: 1 
#> 'data.frame':	1 obs. of  2 variables:
#>  $ AUC: num 0.6
#>  $ R2 : num 0.2