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

get_students

R Documentation

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

Description

Connect to Students table on PROD1 in Schools schema

Usage

get_students()

Value

a ⁠tbl_sql SQL Server⁠ object.

Examples


# This attaches to the school db with \code{conn_PROD1} connection
## Not run: 
stus <- get_students()

## End(Not run)

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

## Not run: 
schools <- get_schools() %>%
  collect() %>%
  clean_names()
  
## End(Not run)

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