ezr.sql_sample_query: Title Sample Table Results

Description Usage Arguments Value

Description

Intent of this function is to examine contents of a database table. A safety limit of 20 rows is applied by default so you don't accidentally query a massive table.

Usage

1
ezr.sql_sample_query(tbl_name, con = con, limit_rows = 20)

Arguments

tbl_name

The database table name. An example would be 'customers' or 'sales'

con

The connection name. The default connection name is 'con' that you used when you initiated the connection with the DB. Change it if you called it something else.

limit_rows

Default is 20 rows. This prevents accidental large queries.

Value

Returns a dataframe of results


jmp1989/easyr documentation built on May 20, 2019, 7:25 a.m.