get_data: Pass a query to a database and get a table back

Description Usage Arguments Value

View source: R/get_data.R

Description

Pass a query to a database and get a table back

Usage

1
get_data(conn, query, cast_as_tibble = TRUE, simplify_dates = TRUE)

Arguments

conn

pass in connection string if created elsewhere (this is optional)

query

a text query in quotes ('select * from tbl') or a network path to a saved sql query (/path/saved_query.sql)

cast_as_tibble

make the output a tibble

simplify_dates

transform all dates in returned table from datetime to just date

Value

a table of data output specified by the query


eauleaf/easydbconn documentation built on Dec. 20, 2021, 3:12 a.m.