Skip to content

Calculated Fields and Engagement Task Fix

Compare
Choose a tag to compare
@fivetran-joemarkiewicz fivetran-joemarkiewicz released this 21 Sep 15:36
402fe7b

Happy Tuesday!

This release of the dbt_hubspot_source Fivetran dbt package includes the following non-breaking changes and updates:

  • Addition of the hubspot__deal_calculated_fields, hubspot__company_calculated_fields, hubspot__contact_calculated_fields, and hubspot__ticket_calculated_fields calculated field variables to allow users to define and pass their own calculated fields through the staging models.
  • Correction within stg_hubspot__engagement_task model to only perform the safe_cast util on the completion_date if the field is not already a timestamp. The conditional logic applied checks the datatype of the field, and if the field is not a UTC timestamp then it will safe cast accordingly.

Huge shoutout to @joellabes for bringing up the calculated fields variable idea and @brettkobo for raising the timestamp casting to our attention! 🎉