dbt_quickbooks/dbt_project.yml at main · fivetran/dbt_quickbooks · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
config-version: 2
name: 'quickbooks'

version: '1.4.2'

require-dbt-version: [">=1.3.0", "<3.0.0"]

models:
  quickbooks:
    +materialized: table
    +schema: quickbooks
    double_entry_transactions:
      +schema: quickbooks_intermediate
      +materialized: table
    transaction_lines:
      +materialized: ephemeral
    intermediate:
      +materialized: ephemeral
    staging:
      +schema: quickbooks_staging
      +materialized: table
      tmp:
        +materialized: view

vars:
  quickbooks:
    account: "{{ source('quickbooks', 'account') }}"
    address: "{{ source('quickbooks', 'address') }}"
    bill_line: "{{ source('quickbooks', 'bill_line') }}"
    bill_linked_txn: "{{ source('quickbooks', 'bill_linked_txn') }}"
    bill_payment_line: "{{ source('quickbooks', 'bill_payment_line') }}"
    bill_payment: "{{ source('quickbooks', 'bill_payment') }}"
    bill: "{{ source('quickbooks', 'bill') }}"
    bundle_item: "{{ source('quickbooks', 'bundle_item') }}"
    bundle: "{{ source('quickbooks', 'bundle') }}"
    credit_memo_line: "{{ source('quickbooks', 'credit_memo_line') }}"
    credit_memo: "{{ source('quickbooks', 'credit_memo') }}"
    credit_card_payment_txn: "{{ source('quickbooks', 'credit_card_payment_txn') }}"
    customer: "{{ source('quickbooks', 'customer') }}"
    department: "{{ source('quickbooks', 'department') }}"
    deposit_line: "{{ source('quickbooks', 'deposit_line') }}"
    deposit: "{{ source('quickbooks', 'deposit') }}"
    estimate: "{{ source('quickbooks', 'estimate') }}"
    estimate_line: "{{ source('quickbooks', 'estimate_line') }}"
    invoice_line: "{{ source('quickbooks', 'invoice_line') }}"
    invoice_line_bundle: "{{ source('quickbooks', 'invoice_line_bundle') }}"
    invoice_linked_txn: "{{ source('quickbooks', 'invoice_linked_txn') }}"
    invoice: "{{ source('quickbooks', 'invoice') }}"
    invoice_tax_line: "{{ source('quickbooks','invoice_tax_line') }}"
    item: "{{ source('quickbooks', 'item') }}"
    journal_entry_line: "{{ source('quickbooks', 'journal_entry_line') }}"
    journal_entry: "{{ source('quickbooks', 'journal_entry') }}"
    journal_entry_tax_line: "{{ source('quickbooks','journal_entry_tax_line') }}"
    payment_line: "{{ source('quickbooks', 'payment_line') }}"
    payment: "{{ source('quickbooks', 'payment') }}"
    purchase_line: "{{ source('quickbooks', 'purchase_line') }}"
    purchase: "{{ source('quickbooks', 'purchase') }}"
    purchase_tax_line:  "{{ source('quickbooks','purchase_tax_line') }}"
    purchase_order_line: "{{ source('quickbooks','purchase_order_line') }}"
    purchase_order: "{{ source('quickbooks','purchase_order') }}"
    purchase_order_linked_txn: "{{ source('quickbooks','purchase_order_linked_txn') }}"
    refund_receipt_line: "{{ source('quickbooks', 'refund_receipt_line') }}"
    refund_receipt: "{{ source('quickbooks', 'refund_receipt') }}"
    refund_receipt_tax_line: "{{ source('quickbooks','refund_receipt_tax_line') }}"
    sales_receipt_line: "{{ source('quickbooks', 'sales_receipt_line') }}"
    sales_receipt: "{{ source('quickbooks', 'sales_receipt') }}"
    sales_receipt_tax_line: "{{ source('quickbooks','sales_receipt_tax_line') }}"
    tax_agency: "{{ source('quickbooks','tax_agency') }}"
    tax_rate: "{{ source('quickbooks','tax_rate') }}"
    transfer: "{{ source('quickbooks', 'transfer') }}"
    vendor_credit_line: "{{ source('quickbooks', 'vendor_credit_line') }}"
    vendor_credit: "{{ source('quickbooks', 'vendor_credit') }}"
    vendor: "{{ source('quickbooks', 'vendor') }}"

    financial_statement_ordinal: []
    cash_flow_statement_type_ordinal: []

    using_address: true
    using_bill: true
    using_credit_memo: true
    using_department: true
    using_deposit: true
    using_estimate: true
    using_invoice: true
    using_invoice_bundle: true
    using_journal_entry: true
    using_payment: true
    using_refund_receipt: true
    using_transfer: true
    using_vendor_credit: true
    using_sales_receipt: true
    using_credit_card_payment_txn: false
    using_purchase_order: false
    using_purchase_tax_line: false
    using_sales_receipt_tax_line: false
    using_refund_receipt_tax_line: false
    using_invoice_tax_line: false
    using_tax_agency: false
    using_tax_rate: false

analysis-paths: ["analysis"]
clean-targets:
- target
- dbt_modules
- dbt_packages