get_unique_ids: Gets all columns that are unique identifiers from a list of...

Description Usage Arguments Examples

View source: R/exploratory_functions.R

Description

This function returns a data.frame that gives all unique columns found in the tables provided from a given database

Usage

1
get_unique_ids(table_char_vect, conn, samp_num)

Arguments

table_char_vect:

a character vector containing the table names to inspect for unique columns

conn:

ODBC database handle

samp_num:

integer indicating the number of rows to sample

Examples

1
get_unique_ids(c('jerrys_table', 'jans_table', conn, 1000) # for obtaining unique identifiers from jan and jerrys table by checking 1000 randomly sample rows from each table

zbeaver4/beavR documentation built on May 4, 2019, 9:12 p.m.