fivetran/dbt_quickbooks v0.7.0

v0.7.0 dbt_quickbooks

on GitHub

An unhappy National Opposite Day to you! ◀️ I hope you all are having a very unpleasant week!

Another unhappy 😉 development is the release of the dbt_quickbooks package. Thankfully, there aren't too many updates!

🚨 Breaking Changes 🚨:

• Added transaction_source to generate_surrogate_key function to fix unique_id uniqueness issues in the quickbooks__general_ledger model. A full refresh is recommended for accurate and consistent surrogate keys, for more information please refer to dbt-utils release notes regarding generate_surrogate_key. (#62)

Additional Features

• Created the quickbooks__cash_flow_statement model so customers can more easily produce their own cash flow statements. Default categorizations are created in int_quickbooks__cash_flow_classifications, where each account line is assigned a cash_flow_type, with main types being Cash or Cash Equivalents, Operating, Investing, and Financing. The ordinal value is also created based on the cash_flow_type for ordering purposes. All values created are based on cash flow best practices. (#69)
• For the quickbooks__cash_flow_statement, customers can create and configure their own cash_flow_type and ordinal for ordering purposes. See the README for details and use the seed cash_flow_statement_type_ordinal_example file for guidance). (#69)
• Added account_ordinal value to quickbooks__general_ledger_by_period, quickbooks__balance_sheet and quickbooks__profit_and_loss to allow customers to order their financial reports based on the account field values. The ordinals can be further configured by the customer. See the README for details and use the seed financial_statement_ordinal_example file for guidance). (#65) (#66)
• Added class_id to quickbooks__general_ledger, quickbooks_general_ledger_by_period, and quickbooks__balance_sheet; add in class values for all intermediate models necessary to pass into final models. (#58).
• Added source_relation field to all Quickbooks models to allow customers, if they have multiple Quickbooks connectors, to union them inside the package. (#62).
• Added tests to all final models, particularly to test uniqueness across a combination of columns, including source_relation. (#62)
• Modified int_quickbooks__retained_earnings intermediate model to accurately reflect account_name field, from "Net Income / Retained Earnings Adjustment" to "Net Income Adjustment". (#66)
• Updated README to follow latest package standards. (#71)
• Added quickbooks_[source_table_name]_identifier variables so it's easier to refer to source tables with different names. (#71)