read_tessi — read_tessi • tessilake

Thin wrapper on read_sql_table using the tables configured in list_tessi_tables that also :

updates customer_no based on merges and adds group_customer_no based on tessi_customer_no_map()

Usage

read_tessi(
  table_name,
  select = NULL,
  freshness = as.difftime(7, units = "days"),
  incremental = TRUE,
  ...
)

table_name: character name of the table to read from Tessitura, either one of the available tables (see tessi_list_tables()) or the name of a SQL table that exists in Tessitura. The default SQL table schema is dbo.
select: vector of strings indicating columns to select from database
freshness: the returned data will be at least this fresh
incremental: whether or not to load data incrementally, default is TRUE
...: further arguments to be passed to read_sql_table

an Apache arrow::Table.

if (FALSE) { # \dontrun{
read_tessi("memberships",
  select = c("memb_level", "customer_no")
)
} # }