dbskim: Skim a database table, getting usefulsummary statistics

Description Usage Arguments Value Examples

View source: R/dbskim.R

Description

'dbskim()' is inspired by skim, quickly providing an overview of all the column names, types, and summary stats of a database table.

Usage

1
dbskim(table_name, conn)

Arguments

table_name

Database table name #TODO: support schemas

conn

Database connection

Value

tibble of table summary statistics

Examples

1
2
3
4
conn <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
DBI::dbWriteTable(conn, "storms", dplyr::storms)
dbskim("storms", conn)
DBI::dbDisconnect(conn)

isteves/dbskimr documentation built on May 3, 2020, 1:38 p.m.