Skip to content

v0.3.2-a1 dbt_zuora

Pre-release
Pre-release
Compare
Choose a tag to compare
@fivetran-avinash fivetran-avinash released this 12 Feb 22:41

This pre-release introduces the following updates.

Bug Fixes (originating within the upstream zuora_source package):

  • Leveraged the {{ dbt.type_timestamp() }} macro within staging models for all timestamp fields. Certain Redshift warehouses sync these fields as timestamp with time zone fields by default, causing errors in the zuora package. This macro appropriately removes timezone values from the UTC timestamps and ensures successful compilations of these models.
  • For more details, please refer to the relevant dbt_zuora_source v0.2.2-a1 release.
  • Updated subscription_period_started_at and subscription_period_ended_at with the {{ dbt.type_timestamp() }} cast in zuora__line_item_enhanced to remove date/timestamp mismatches on the union all function. (#20)

Under the Hood

  • Replaced the deprecated dbt.current_timestamp_backcompat() function with dbt.current_timestamp() to ensure all timestamps are captured in UTC. (#20)
  • This change is applied in the following end models:
    • zuora__billing_history
    • zuora__line_item_history
    • zuora__subscription_overview
  • As well as the intermediate models:
    • int_zuora__account_enriched
    • int_zuora__mrr_date_spine
    • int_zuora__transaction_date_spine
  • Added consistency tests within integration_tests for the zuora__billing_history and zuora__subscription_overview models. (#20)

Documentation

  • Added Quickstart model counts to README. (#19)
  • Corrected references to connectors and connections in the README. (#19)

Full Changelog: v0.3.1...v0.3.2-a1