Skip to content

v0.5.0 dbt_sage_intacct

Latest
Compare
Choose a tag to compare
@fivetran-data-model-bot fivetran-data-model-bot released this 01 Aug 21:01
· 2 commits to main since this release
b77ddf2

PR #24 includes the following updates.

🚨 Breaking Changes: Bug Fixes 🚨

  • Updated the structure of the int_sage_intacct__general_ledger_date_spine model for improved performance and maintainability.
    • Modified the date spine logic so that the model will take the maximum entry_date_at from the sage_intacct__general_ledger for the last date of the spine if it is available, rather than the current date. This will help capture future-dated transactions as well beyond the current date.
    • This is a breaking change, as changing the behavior of the date spine which will adjust the transaction records in the sage_intacct__general_ledger_by_period model to be more accurate.

Bug Fixes

  • Updated the int_sage_intacct__general_ledger_date_spine model to accommodate for the cases when the compiled sage_intacct__general_ledger model has no transactions. In this case, the model now defaults to a range of one month leading up to the current date.

Under The Hood

  • Added flags.WHICH in ('run', 'build') as a condition in int_sage_intacct__general_ledger_date_spine to prevent call statements from querying the staging models during a dbt compile.
  • Addition of integrity and consistency validation tests within integration tests for the sage_intacct__general_ledger and sage_intacct__general_ledger_by_period model.

Full Changelog: v0.4.0...v0.5.0