read_tessi: read_tessi

In skysyzygy/tessilake: Data lake for Tessitura

read_tessi

Description

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,
  ...
)

Arguments

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

Value

an Apache arrow::Table.

Examples

## Not run: 
read_tessi("memberships",
  select = c("memb_level", "customer_no")
)

## End(Not run)

skysyzygy/tessilake documentation built on June 14, 2025, 6:50 p.m.