Skip to content

v0.9.0 dbt_salesforce

Compare
Choose a tag to compare
@fivetran-reneeli fivetran-reneeli released this 08 May 14:36
· 79 commits to main since this release
v0.9.0
357b1cb
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.

🚨 Breaking Changes 🚨:

PR #38 includes the following breaking changes:

  • Updates the old passthrough column methodology to allow for aliasing and/or transformations of any field names brought in. This is useful, for example, if you wish to bring in fields across different Salesforce objects that may have the same names and wish to alias them to avoid confusion, particularly if any of the objects are joined together.

  • Additionally, in the salesforce__opportunity_enhanced model, the old opportunity_enhanced_pass_through_columns variable has been replaced with the existing variables from the staging models (see below). This is because we updated the salesforce__opportunity_enhanced model with regards to how custom fields passed through from the user table are dealt with. Since the user model is joined in two times, once as information about an opportunity owner and the other about an opportunity manager, to avoid ambiguity, custom fields passed through from the user table will be suffixed based on whether it belongs to a user who is an _owner or a _manager.

  • Finally, we have added the salesforce__ prefix to all the passthrough variables:

Old New
account_pass_through_columns salesforce__account_pass_through_columns
contact_pass_through_columns salesforce__contact_pass_through_columns
event_pass_through_columns salesforce__event_pass_through_columns
lead_pass_through_columns salesforce__lead_pass_through_columns
opportunity_pass_through_columns salesforce__opportunity_pass_through_columns
opportunity_line_item_pass_through_columns salesforce__opportunity_line_item_pass_through_columns
order_pass_through_columns salesforce__order_pass_through_columns
product_2_pass_through_columns salesforce__product_2_pass_through_columns
task_pass_through_columns salesforce__task_pass_through_columns
user_role_pass_through_columns salesforce__user_role_pass_through_columns
user_pass_through_columns salesforce__user_pass_through_columns

Under the Hood:

  • Incorporated the new fivetran_utils.drop_schemas_automation macro into the end of each Buildkite integration test job.
  • Updated the pull request templates.
Assets 2
Loading