Skip to content

dbt_klaviyo 0.3.0
Compare
Choose a tag to compare
@fivetran-jamie fivetran-jamie released this 02 Nov 20:32
· 146 commits to main since this release
v0.3.0
ff9ba96
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.

Happy Tuesday! This 0.3.0 release of the dbt_klaviyo package contains the below changes. Refer to the CHANGELOG for additional information on the below changes.

Features

  • Allow for multiple sources by unioning source tables across multiple Klaviyo connectors.
    (#11 & #12)
    • Refer to the README for more details.

Bug Fixes

  • Correct README in pointing out that the klaviyo__eligible_attribution_events variable is case-SENSITIVE and must be in all lowercase.

Under the Hood

  • Unioning: The unioning occurs in the staging tmp models using the fivetran_utils.union_data macro. (#8)
  • Unique tests: Because columns that were previously used for unique tests may now have duplicate fields across multiple sources, these columns are combined with the new source_relation column for unique tests and tested using the dbt_utils.unique_combination_of_columns macro. (#8)
  • Source Relation column: To distinguish which source each record comes from, we added a new source_relation column in each staging and final model and applied the fivetran_utils.source_relation macro. (#8)
    • The source_relation column is included in all joins and window function partition clauses in the transform package. Note that an event from one Klaviyo source will never be attributed to an event from a different Klaviyo connector.

Contributors

Assets 2
Loading