PR #141 includes the following updates:
Schema/Data Changes
3 total changes • 0 possible breaking changes
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
stripe__subscription_item_mrr_report
| Changed data | Discount sourced from discount table
| Discount sourced from subscription_discount table
| Affects discount-based MRR calculations for subscriptions with active coupons. |
stg_stripe__subscription_discount
| New Staging Model | Staging model for subscription discount data. This table is enabled by default, and can be disabled via variable configurability. See the README for more details. | ||
stg_stripe__subscription_discount_tmp
| New Temp Model |
Bug Fixes
- Removes
convert_valuesmacro fromamountcalculation instripe__subscription_item_mrr_report. The macro is already applied at the staging layer and applying it to the metric calculation was causing a double conversion, leading to potential undercalculation of MRR values whenstripe__convert_valueswas set to true. - Adds
convert_valuesmacro toamount_offfield value instg_stripe__coupontable to ensure correct conversion of discounted amount when customers have the variable set to true.
Under the Hood
- Updates
int_stripe__subscription_discountto source from thesubscription_discounttable via the newstg_stripe__subscription_discountstaging model, instead of sourcing from thediscounttable viastg_stripe__discount. - Adds integration test seed files
subscription_discount_data.csv,subscription_discount_data_snowflake.csv, andsubscription_discount_data_postgres.csv.
Full Changelog: v1.5.0...v1.6.0