qlook: Quick look at remote data

View source: R/RowsColsQ.R

qlookR Documentation

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.