get_schools: Connect to 'Schools' table on 'PROD1' in 'Schools' schema
In idea-analytics/ideadata: Tools and Utilities for accessing IDEA's Data Warehouse

get_schools

R Documentation

Connect to `Schools` table on `PROD1` in `Schools` schema

Description

Connect to Schools table on PROD1 in Schools schema

Usage

get_schools()

Value

a ⁠tbl_sql SQL Server⁠ object.

Examples


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

## Not run: 
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()
  
## End(Not run)

idea-analytics/ideadata documentation built on Feb. 1, 2024, 5:40 a.m.