Skip to content

v0.1.0 dbt_zuora

Compare
Choose a tag to compare
@fivetran-joemarkiewicz fivetran-joemarkiewicz released this 28 Apr 00:52
· 51 commits to main since this release
4b0f21f

🎉 This is the initial release of this package! 🎉

📣 What does this dbt package do?

  • Produces modeled tables that leverage Zuora data from Fivetran's connector in the format described by this ERD and build off the output of our Zuora source package.
  • The above mentioned models enable you to better understand your Zuora performance metrics at different granularities. It achieves this by:
    • Providing intuitive reporting at the account and the subscription levels.
    • Creates a billing history model at the invoice level and a line item history model to evaluate data at the invoice item level.
    • Builds a daily overview of account balance activity using the billing history data.
    • Generates a monthly recurring revenue table at the account level.
    • A churn analysis model is also available in the analysis folder to evaluate account churn at the monthly level. More details area available in the DECISIONLOG.
  • Generates a comprehensive data dictionary of your source and modeled Zuora data through the dbt docs site.

For more information, refer to the README.