To use this dbt package, you must have the following:
quickbooks
transformation package)If you are not using the QuickBooks transformation package, include the following quickbooks_source
package version in your packages.yml
file.
TIP: Check dbt Hub for the latest installation instructions or read the dbt docs for more information on installing packages.
packages:
- package: fivetran/quickbooks_source
version: [">=0.9.0", "<0.10.0"] # we recommend using ranges to capture non-breaking changes automatically
By default, this package runs using your destination and the quickbooks
schema of your target database. If this is not where your QuickBooks data is (for example, if your QuickBooks schema is named quickbooks_fivetran
), add the following configuration to your root dbt_project.yml
file:
vars:
quickbooks_database: your_destination_name
quickbooks_schema: your_schema_name
Your QuickBooks connector might not sync every table that this package expects. This package takes into consideration that not every QuickBooks account utilizes the same transactional tables.
By default, most variables' values are assumed to be true
(with exception of using_purchase_order
and using_credit_card_payment_txn
). In other to enable or disable the relevant functionality in the package, you will need to add the relevant variables:
vars:
using_address: false # disable if you don't have addresses in QuickBooks
using_bill: false # disable if you don't have bills or bill payments in QuickBooks
using_credit_memo: false # disable if you don't have credit memos in QuickBooks
using_department: false # disable if you don't have departments in QuickBooks
using_deposit: false # disable if you don't have deposits in QuickBooks
using_estimate: false # disable if you don't have estimates in QuickBooks
using_invoice: false # disable if you don't have estimates in QuickBooks
using_invoice_bundle: false # disable if you don't have estimates in QuickBooks
using_journal_entry: false # disable if you don't have estimates in QuickBooks
using_payment: false # disable if you don't have estimates in QuickBooks
using_refund_receipt: false # disable if you don't have estimates in QuickBooks
using_transfer: false # disable if you don't have estimates in QuickBooks
using_vendor_credit: false # disable if you don't have estimates in QuickBooks
using_sales_receipt: false # disable if you don't have estimates in QuickBooks
using_purchase_order: true # enable if you want to include purchase orders in your staging models
using_credit_card_payment_txn: true # enable if you want to include credit card payment transactions in your staging models
This dbt package is dependent on the following dbt packages. These dependencies are installed by default within this package. For more information on the following packages, refer to the dbt hub site.
IMPORTANT: If you have any of these dependent packages in your own
packages.yml
file, we highly recommend that you remove them from your rootpackages.yml
to avoid package version conflicts.
packages:
- package: fivetran/fivetran_utils
version: [">=0.4.0", "<0.5.0"]
- package: dbt-labs/dbt_utils
version: [">=1.0.0", "<2.0.0"]
The Fivetran team maintaining this package only maintains the latest version of the package. We highly recommend that you stay consistent with the latest version of the package and refer to the CHANGELOG and release notes for more information on changes across versions.
A small team of analytics engineers at Fivetran develops these dbt packages. However, the packages are made better by community contributions.
We highly encourage and welcome contributions to this package. Check out this dbt Discourse article to learn how to contribute to a dbt package.