tessi_list_tables: tessi_list_tables

In skysyzygy/tessilake: Data lake for Tessitura

tessi_list_tables

Description

The list of Tessitura tables is configured in the extdata/tessi_tables.yml file in the package directory supplemented by the tessi_tables dictionary in config.yml

Usage

tessi_list_tables()

Details

yml format

{short_name}:
   long_name: {name of table/view to be loaded}
   base_table: {the underlying table being queried that has primary_keys}
   primary_keys: {the primary key(s) as a value or a list of values}

Value

data.table of configured Tessitura tables with columns short_name, long_name, base_table and primary_keys

Examples

# customers:
#   long_name: BI.VT_CUSTOMER
#   base_table: T_CUSTOMER
#   primary_keys: customer_no

tessi_list_tables()[short_name == "customers"]

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