This release includes the following updates:
Schema/Data Changes (--full-refresh required after upgrading)
3 total changes • 3 possible breaking changes
| Data Model(s) | Change type | Field(s) | Old | New | Notes |
|---|---|---|---|---|---|
shopify_gql__customer_cohortsshopify_gql__customer_email_cohortsshopify__customer_email_cohorts
| Data change | cohort_month_numbertotal_price_lifetimeorder_count_lifetimeline_item_count_lifetime
| May contain null values on incremental runs | Properly calculated values | PR #152 |
Bug Fix
- Resolves an intermittent Databricks error in
shopify__customer_emailsandshopify_gql__customer_emailscaused by a non-deterministicrow_number()window function inint_shopify__customer_email_rollupandint_shopify_gql__customer_email_rollup. The ordering now includescustomer_idas a tiebreaker so results are deterministic when multiple customers share the same email andcreated_timestamp. (#154)
Full Changelog: v1.6.0...v1.7.0