In UniversityOfSaintThomas/ustr: Templates, functions, and themes for the University of St. Thomas IDAR team.

knitr::opts_chunk$set(echo = FALSE, fig.width = 6.5, message = FALSE, warning = FALSE, cache = FALSE, dpi = 700)
options(tibble.print_max = 50, tibble.print_min = 20)

#tidyverse
library(tidyverse)
library(odbc)
library(DBI)
library(lubridate)
library(readxl)
library(writexl)
library(broom)

#formatting
library(extrafont)
library(knitr)
library(scales)
library(janitor)
library(ggrepel)

#ust package
library(ustr)
#set ust ggplot theme
theme_set_ust_doc()

con <- DBI::dbConnect(odbc::odbc(), dsn = "dsn_name", uid = Sys.getenv("userid"), pwd = Sys.getenv("pwd"))

df <- dbGetQuery(con, statement = read_file("your_sql_file.sql"))

UniversityOfSaintThomas/ustr documentation built on April 23, 2020, 12:44 a.m.