Skip to content

v2.4.0 dbt_salesforce

Choose a tag to compare

@fivetran-data-model-bot fivetran-data-model-bot released this 05 Aug 15:09
· 1 commit to main since this release
a9d2b20

This release includes the following updates:

The account, campaign, contact, and opportunity daily history models, and their related variables, are not currently available in Quickstart.

Schema/Data Change (--full-refresh required after upgrading)

1 total change • 1 possible breaking change

Data Model(s) Change type Old New Notes
stg_salesforce__account_history
stg_salesforce__contact_history
stg_salesforce__opportunity_history
Removed model BREAKING: Run --full-refresh on the three daily history models after upgrading.

salesforce__account_daily_history, salesforce__contact_daily_history, and salesforce__opportunity_daily_history now read directly from the salesforce_history sources, matching the salesforce__campaign_daily_history pattern

Bug Fix

  • Fixes an issue in salesforce__account_daily_history, salesforce__campaign_daily_history, salesforce__contact_daily_history, and salesforce__opportunity_daily_history where a record that remained current but hadn't changed recently could stop receiving new daily rows on incremental runs. Currently active records now continue to receive a daily row regardless of how recently they last changed. Requires --full-refresh to backfill any rows that were previously missing.

Feature Update

  • Adds a configurable lookback_window variable (default 1 day) to salesforce__account_daily_history, salesforce__campaign_daily_history, salesforce__contact_daily_history, and salesforce__opportunity_daily_history. Each incremental run now reprocesses the last lookback_window days in addition to any new dates, so a corrected or backfilled history record landing within that window is picked up automatically instead of requiring a --full-refresh.

Full Changelog: v2.3.0...v2.4.0