PR #178 includes the following updates:
Breaking Changes
Source Package Consolidation
- Removed the dependency on the
fivetran/quickbooks_sourcepackage.- All functionality from the source package has been merged into this transformation package for improved maintainability and clarity.
- If you reference
fivetran/quickbooks_sourcein yourpackages.yml, you must remove this dependency to avoid conflicts. - Any source overrides referencing the
fivetran/quickbooks_sourcepackage will also need to be removed or updated to reference this package. - Update any
quickbooks_source-scoped variables to be scoped to only under this package. See the README for how to configure the build schema of staging models.
- As part of the consolidation, vars are no longer used to reference staging models, and only sources are represented by vars. Staging models are now referenced directly with
ref()in downstream models.
Schema Updates
14 new models -- 14 potential breaking changes
NOTE: These models are not available to Quickstart users until we have validated tax lines work as expected. Please open a Fivetran support ticket if you'd like to try out the pre-release that contains tax line support. They are available for dbt Core customers only if you enable the appropriate variables (see the README for more details).
| Data Model | Change Type | Old Name | New Name | Notes |
|---|---|---|---|---|
stg_quickbooks__invoice_tax_line
| New Staging Model | Source: invoice_tax_line table. Disabled by default, leverage using_invoice_tax_line variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__journal_entry_tax_line
| New Staging Model | Source: journal_entry_tax_line table. Disabled by default, leverage using_journal_entry_tax_line variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__purchase_tax_line
| New Staging Model | Source: purchase_tax_line table. Disabled by default, leverage using_purchase_tax_line variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__refund_receipt_tax_line
| New Staging Model | Source: refund_receipt_tax_line table. Disabled by default, leverage using_refund_receipt_tax_line variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__sales_receipt_tax_line
| New Staging Model | Source: sales_receipt_tax_line table. Disabled by default, leverage using_sales_receipt_tax_line variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__tax_agency
| New Staging Model | Source: tax_agency table. Disabled by default, leverage using_tax_agency variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__tax_rate
| New Staging Model | Source: tax_rate table. Disabled by default, leverage using_tax_rate variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__invoice_tax_line_tmp
| New Temp Model | Source: invoice_tax_line table. Enabled by default, leverage using_invoice_tax_line variable in dbt_project.yml to disable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__journal_entry_tax_line_tmp
| New Temp Model | Source: journal_entry_tax_line table. Disabled by default, leverage using_journal_entry_tax_line variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__purchase_tax_line_tmp
| New Temp Model | Source: purchase_tax_line table. Disabled by default, leverage using_purchase_tax_line variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__refund_receipt_tax_line_tmp
| New Temp Model | Source: refund_receipt_tax_line table. Disabled by default, leverage using_refund_receipt_tax_line variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__sales_receipt_tax_line_tmp
| New Temp Model | Source: sales_receipt_tax_line table. Disabled by default, leverage using_sales_receipt_tax_line variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__tax_agency_tmp
| New Temp Model | Source: tax_agency table. Disabled by default, leverage using_tax_agency variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
| ||
stg_quickbooks__tax_rate_tmp
| New Temp Model | Source: tax_rate table. Disabled by default, leverage using_tax_rate variable in dbt_project.yml to enable. (Once available in a future update, this will be dynamically handled for Quickstart users.)
|
Bug Fixes
- Corrected the
int_quickbooks__invoice_double_entrymodel to accurately map bundled invoice lines to the correctamount,converted_amount,account_id,index, andclass_id.
Under the Hood
- Updated seed files to ensure accurate representation of invoice bundles.
- Updated
run_models.shto execute for when the new variables are enabled. - Updated
general_ledger_amounts_matchintegrity test to properly validate general ledger amounts. - Excluded the
running_balanceandcumulative_running_balancevalues from theconsistency_general_ledgervalidation test as these results can change based on how the window function orders transactions on the same date.
Full Changelog: v0.21.1...v1.0.0