PR #158 includes the following updates:
Schema/Data Change
5 total changes • 4 possible breaking changes
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
stripe__daily_overview
| Changed field (breaking change) | surrogate key hashed on account_id and date_day.
| surrogate key hashed on source_relation, account_id, and date_day.
| Two unioned connectors that share an account ID and a date previously produced the same key. |
stripe__daily_overview
| Possible changed data (possible breaking change) | Each rolling_* column accumulated across all accounts.
| Each rolling_* column is the running total of its own account_id and source_relation.
| Only affects destinations with more than one account or more than one unioned connector. Single-account output is unchanged. See #155. |
stripe__daily_overviewint_stripe__account_daily
| Changed join (possible breaking change) | Balance transactions and failed charges join to the date spine on the date and source_relation only, so every account counts every other account's activity as its own.
| Both joins also match on the account. | Only affects destinations with more than one account. Transactions with no connected_account_id still count toward every account; see the DECISIONLOG for why. Single-account output is unchanged.
|
stripe__subscription_item_mrr_report
| Changed model (possible breaking change) | Historical months apply the item's current price_plan unit amount.
| Historical months apply the unit_amount_excluding_tax from the invoice line that billed them, carried forward across gap months.
| MRR now reflects a price change from the month it took effect instead of applying today's price across all history, so historical month_contract_mrr, month_discount_applied, month_billed_mrr, and contract_mrr_type values change. Months with no invoiced unit amount still use the live price_plan unit amount. See the DECISIONLOG.
|
stg_stripe__invoice_line_item
| New field | unit_amount_excluding_tax
|
Contributors
Full Changelog: v1.9.0...v1.10.0