v0.12.0 dbt_quickbooks_source

PR #58 introduces the following updates:

Breaking Changes

• Introduced the following timestamp fields to the listed stg_quickbooks__* models to better analyze real-time transaction data:
  • created_at: bill, bill_payment, credit_memo, invoice, payment, transfer
  • updated_at: bill, bill_payment, credit_memo, deposit, invoice, journal_entry, payment, purchase, refund_receipt, sales_receipt, transfer, vendor_credit
• These new fields are incorporated in the dbt_quickbooks package's quickbooks__general_ledger model via the *_double_entry intermediate models. You can learn more about these changes in the v0.17.0 release of the dbt_quickbooks package.
• As this introduces new columns to our staging models and changes our schema, this is a breaking change.

Full Changelog: v0.11.0...v0.12.0

v0.11.0 dbt_quickbooks_source

PR #57 introduces the following updates:

Breaking Changes

• We are currently bringing in records that have previously been deleted, which could be impacting reporting accuracy. Thus, we introduced the _fivetran_deleted field to filter out these records from the following staging models:
  • stg_quickbooks__account
  • stg_quickbooks__bundle
  • stg_quickbooks__customer
  • stg_quickbooks__department
  • stg_quickbooks__item
  • stg_quickbooks__vendor
• As this will filter out deleted records that were previously being counted and we are adding a new field to these staging models, this will be a breaking change here and in dbt_quickbooks.

Documentation Updates

• Added the _fivetran_deleted field to src_quickbooks and stg_quickbook yml documentation.
• Added the _fivetran_deleted field to the above corresponding seed files in integration tests.

Contibutors

• @brandonrf94 (PR #56)

Full Changelog: v0.10.1...v0.11.0

v0.10.1 dbt_quickbooks_source

PR #53 introduces the following updates:

🎉 Feature Update 🎉

• Added the following fields to support the new multicurrency feature in the v0.14.0 release of the dbt_quickbooks package:
  • home_total_amount, into stg_quickbooks__deposit.
  • exchange_rate, into stg_quickbooks__estimate.

🚘 Under the Hood 🚘

• Included auto-releaser GitHub Actions workflow to automate future releases.
• Updated the maintainer PR template to resemble the most up to date format.
• Removed the check docs GitHub Action as it is no longer necessary.

Documentation Update

• Added exchange_rate and home_total_amount fields and descriptions into the relevant yml documents.

Full Changelog: v0.10.0...v0.10.1

v0.10.0 dbt_quickbooks_source

🚨 Breaking Change 🚨 :

PR #51 includes the following updates:

🚘 Under the Hood

• Explicitly casts *_date fields as date type (due_date, transaction_date). Previously, some fields were getting interpreted as timestamps while some were interpreted as dates, leading to errors on downstream joins.
• Updated seed files to correct timestamp formats.

This will be a breaking change to those whose source tables still use the old timestamp formats, so please update your package version accordingly.

Full Changelog: v0.9.1...v0.10.0

v0.9.1 dbt_quickbooks_source

PR #49 includes the following updates:

🎉 Features

• Added description for column source_relation to the documentation.

🚘 Under the Hood

• Updated partitioning in stg_quickbooks__credit_card_payment_txn to include source_relation.

Full Changelog: v0.9.0...v0.9.1

v0.9.0 dbt_quickbooks_source

This release of dbt_quickbooks_source includes:

🎉 Feature Update 🎉

• Databricks compatibility! (#48)

Full Changelog: v0.8.0...v0.9.0

v0.8.0 dbt_quickbooks_source

🎉 Feature Updates 🎉

• Addition of the detail_type field within the stg_quickbooks__invoice_line model. This field will help identify the type of invoice line in the context of the entire invoice. (PR #43)

Under the Hood

• Casted the department_id within the following staging models to be of type string. This ensures downstream unions on this type are consistent and of the same type. (PR #44)
  • stg_quickbooks__bill
  • stg_quickbooks__bill_payment
  • stg_quickbooks__credit_memo
  • stg_quickbooks__department
  • stg_quickbooks__deposit
  • stg_quickbooks__estimate
  • stg_quickbooks__invoice
  • stg_quickbooks__journal_entry_line
  • stg_quickbooks__purchase
  • stg_quickbooks__refund_receipt
  • stg_quickbooks__sales_receipt
  • stg_quickbooks__vendor_credit

Under the Hood:

• Incorporated the new fivetran_utils.drop_schemas_automation macro into the end of each Buildkite integration test job. (#46)
• Updated the pull request templates. (#46)

Full Changelog: v0.7.1...v0.8.0

v0.7.1 dbt_quickbooks_source

Happy National Gumdrop Day! Hope your sweet tooth gets a wonderful treat today!

Here's updates from the latest release of the new dbt_quickbooks_source package.

🎉 Feature Updates 🎉

• Removed not-null test for bill_payment_id field in stg_quickbooks__bill_linked_txn to account for bills with empty bill payment values. (#41)

v0.7.0 dbt_quickbooks_source

Happy National Compliment Day everyone! Aren't you all looking great today?

You know what else is looking great? The latest release of the new dbt_quickbooks_source package, which is filled with a host of new updates to better assist your financial reporting needs! Here's the latest updates:

🎉 🚨 Breaking Changes and New Feature 🚨 🎉:

• Add union schema ability to run QuickBooks across a number of schemas. (#26) and (#35)

🎉 Additional Features

• Addition of all class_id fields to relevant models to support adding classes upstream into your general ledger models. (#35)
• Updated README to follow latest package standards. (#37)
• Added quickbooks_[source_table_name]_identifier variables so it's easier to refer to source tables with different names. (#37)

🦁 Contributors

• @ligfx (#26)

dbt_quickbooks_source v0.6.0

🚨 Breaking Changes 🚨:

PR #30 includes the following breaking changes:

• Dispatch update for dbt-utils to dbt-core cross-db macros migration. Specifically {{ dbt_utils.<macro> }} have been updated to {{ dbt.<macro> }} for the below macros:
  • any_value
  • bool_or
  • cast_bool_to_text
  • concat
  • date_trunc
  • dateadd
  • datediff
  • escape_single_quotes
  • except
  • hash
  • intersect
  • last_day
  • length
  • listagg
  • position
  • replace
  • right
  • safe_cast
  • split_part
  • string_literal
  • type_bigint
  • type_float
  • type_int
  • type_numeric
  • type_string
  • type_timestamp
  • array_append
  • array_concat
  • array_construct
• For current_timestamp and current_timestamp_in_utc macros, the dispatch AND the macro names have been updated to the below, respectively:
  • dbt.current_timestamp_backcompat
  • dbt.current_timestamp_in_utc_backcompat
• dbt_utils.surrogate_key has also been updated to dbt_utils.generate_surrogate_key. Since the method for creating surrogate keys differ, we suggest all users do a full-refresh for the most accurate data. For more information, please refer to dbt-utils release notes for this update.
• packages.yml has been updated to reflect new default fivetran/fivetran_utils version, previously [">=0.3.0", "<0.4.0"] now [">=0.4.0", "<0.5.0"].

Under the Hood

• A GitHub workflow has been added to ensure the dbt docs are regenerated before each merge to the main release branch.