get_iabwa: Connect to 'IABWA' table on 'PROD2' in 'Assessments' schema
In idea-analytics/ideadata: Tools and Utilities for accessing IDEA's Data Warehouse

get_iabwa

R Documentation

Connect to `IABWA` table on `PROD2` in `Assessments` schema

Description

Connect to IABWA table on PROD2 in Assessments schema

Usage

get_iabwa()

Value

a ⁠tbl_sql SQL Server⁠ object.

Examples


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

## Not run: 
schools <- get_schools()

## 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: 
ias_bwas <- get_ia_bwa() %>%
  filter(AcademicYear == "2020-2021") %>%
  collect() %>%
  clean_names()
  
## End(Not run)

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