Data Definitions

Backbook Gross Profit Databricks

Description

The gross profit from our backbook valuations methodlogy (output of Databricks notebook)

SQL

SELECT sum_revenue - sum_cost
FROM delta.backbook_valuations_last_run_q3_2025
WHERE merchant IN ('Acme',
                   'Core',
                   'Delta')
    AND origination_period NOT IN ('2024-01-01')
Loan Amounts Snowflake

Description

Charge-level data, the loan amount at time of origination

SQL

SELECT loan_amt
FROM originations_updated_q4_2025
WHERE product_type!='deprecated_go'
    AND term_length!=71
    AND merchant IN ('Acme',
                     'Core',
                     'Delta')