PR #138 includes the following updates:
Schema/Data Change
1 total change • 0 possible breaking changes
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
stripe__subscription_item_mrr_report
| New End Model | Each record represents a subscription item for a given month with MRR metrics and movement classification. Tracks MRR changes over time, classifying each month as new, expansion, contraction, churned, reactivation, or unchanged. |
Feature Update
- Adds new analyses folder with compiled SQL for advanced revenue reporting:
stripe__arr_snapshot_analysis: Generates a high-level ARR snapshot report for the entire business for revenue forecasting.stripe__customer_mrr_analysis: Generates an MRR report at the customer level for retention reporting and cohort analysis.- These analysis files reference the
stripe__subscription_item_mrr_reportmodel and can be compiled usingdbt compileand executed directly in your data warehouse.
Bug Fix
- Fixes a circular reference in
stg_stripe__price_planwhere the model incorrectly references itself instead ofstg_stripe__price_plan_tmp, causing compilation errors.
Documentation
- Adds comprehensive column documentation for
stripe__subscription_item_mrr_reportinstripe.yml. - Adds README in the analysis folder with instructions on how to compile and use the analysis SQL.
Under the Hood
- Adds consistency test for
stripe__subscription_item_mrr_reportmodel. - Updates
integration_tests/seeds/price_data.csvwith additional test data.
Full Changelog: v1.2.0...v1.3.0-a1