PR #125 includes the following updates:
Schema/Data Changes
2 total changes • 2 possible breaking changes
| Data Model | Change type | Old | New | Notes |
|---|---|---|---|---|
stg_stripe__subscription_item
| New Staging Model | As of July 31, 2025, new Stripe connections store the subscription current_period_start and current_period_end fields in the SUBSCRIPTION_ITEM source table instead of in SUBSCRIPTION_HISTORY.
| ||
stg_stripe__subscription_item_tmp
| New Staging Model | |||
stripe__subscription_details
| New Source Data | current_period_start/end fields sourced from stg_stripe__subscription_history
| current_period_start/end fields sourced from both stg_stripe__subscription_history and stg_stripe__subscription_item.
| Fields have been coalesced to reference either table, so the package will work for all versions. |
stripe__line_item_enhanced
| New Source Data | current_period_start/end fields sourced from stg_stripe__subscription_history
| current_period_start/end fields sourced from both stg_stripe__subscription_history and stg_stripe__subscription_item.
| Fields have been coalesced to reference either table, so the package will work for all versions. |
- For customers using the >= July 31st version of the connector,
current_period_start/endfields will only populate in thesubscription_itemtable.current_period_start/endfields will populate in thesubscription_historytable for customers using earlier versions of the connector.- Customers using the >= July 31st version of the connector will need to resync to backfill historic data in these columns.
Under the Hood
- Updated the
current_period_start/endfields to be cast asdbt.type_timestamp()within thestg_stripe__subscriptionmodel. This helps ensure an accurate and consistent datatype.
Full Changelog: v1.0.1...v1.1.0