qlook: Quick look at remote data

In cdata: Fluid Data Transformations

Quick look at remote data

Description

Quick look at remote data

Usage

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)
}

cdata documentation built on Aug. 20, 2023, 1:06 a.m.