Connect to Schools table on PROD1 in Schools schema

Connect to Schools table on PROD1 in Schools schema

get_schools()

Value

a tbl_sql SQL Server object.

Examples

# This attaches to the school db with \code{conn_PROD1} connection

if (FALSE) {
schools <- get_schools()


# This pulls down schools data form the DB and onto your computer
# and then cleans the names (lower snakecase) using [janitor::clean_names()]

library(dplyr)
library(janitor)
schools <- get_schools() %>%
  collect() %>%
  clean_names()
  }