Changelog

updated workhorse functions to avoid dependency problem with dbplyr 2.4.0.
added get_aees family of functions to get Annual Employee Experience Survey tables
fixed warehouse_meta_data documentation

fixed loading problems by error catching when not on the network. The package should load without creds as well.

Added a call to data(warhouse_meta_data, envir=environemnt()) to ensure a Linux compatibility with looking up warehouse metadata.

This is the newest version for release to the R&A Team. Biggest change is that get_table doesn’t connect to the warehouse MetaData. It uses a build in dataframe that is refreshed when the package is loaded.
collector now takes multiple columns to split up a data set to pass to purrr.
Minor documentation in collector’s vignette on using dplyr::compute to reduce SQL Server time on unevaluated dplyr pipelines.
added view_warehouse_meta_data(), which opens the RStudio IDE’s viewer for exploring what’s in the data warehouse.

When attaching ideadata with library(ideadata) the package creates a data warehouse meta data table that users can use to look for data locations and which ideadata uses for looking up table locations. This process ensures that at library attach the user and the package has the most up-to-date data about the warehouse.

create a switch in the kinit function to differentiate between macOS and Linux since out of the box Kereberos authentication is slightly different on both.

rolled back the connection function to not perform one check on live connection (it always saw live connections as dead and would reconnect, making joins impossible.)

This is a major release where this package is substantially feature complete.

added the get_table() function which is a workhorse that can pull arbitrary tables in the warehouse with simply the table name. In the case of more than 1 table with the same name, the function fails informatively and provides example code to get the table the user really needs.

added vignettes for collector(), get_tables()
Changed connections strings from using IP addresses to FQDNs in the server argument.

added functions to get engagement data (i.e., in-person vs remote) and continuous enrollment data.

Connection pane disconnections weren’t working, but now they are.
added disconnect() function to close conenctions in scripts and from the console.
Created pkgdown site for hosting documentation on github.

Added linked server functionality.
- Renaissance STAR (math and reading with separate functions) on SRC_AR via linked server.
Added Connection Pane viewer functionality. Now when you open a connection you’ll be able to explore that database to which you are connected. (Note that this doesn’t worked for linked databases; in that case you’ll see the R&A SQL Server)

ideadata 4.0.0