contactually-analytics/dbt_project.yml at develop · contactually/contactually-analytics · 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
#settings specifically for this models directory
#config other dbt settings within ~/.dbt/profiles.yml
name: 'Contactually'
version: '0.0.1'

source-paths: ["models"]
target-path: "target"
clean-targets: ["target"]
test-paths: ["tests"]
analysis-paths: ["analysis"]
data-paths: ["data"]

models:
  post-hook: "grant select on table {{this}} to looker"
  Contactually:
    finance:
      tables:
        finance_cogs:
          materialized: table
          sort: txn_date
          dist: txn_date
        finance_marketing_costs:
          materialized: table
          sort: txn_date
          dist: txn_date

  quickbooks:
    post-hook: "grant select on table {{this}} to looker"
    materialized: ephemeral
    tables:
      materialized: table
      quickbooks_parent_class_map:
    base:
      quickbooks_classes:
        materialized: table
    transform:
      quickbooks_toplevel_account_metrics:
        materialized: table
      quickbooks_toplevel_class_metrics:
        materialized: table

    vars:
      "base.accounts"                     : '{{ ref("quickbooks_accounts") }}'
      "base.bills_line"                   : '{{ ref("quickbooks_bill_lines") }}'
      "base.billpayments"                 : '{{ ref("quickbooks_bill_payments") }}'
      "base.billpayments_line"            : '{{ ref("quickbooks_bill_payments_line") }}'
      "base.billpayments_line__linkedtxn" : '{{ ref("quickbooks_bill_payments_line_transaction") }}'
      "base.bills"                        : '{{ ref("quickbooks_bills") }}'
      "base.classes"                      : '{{ ref("quickbooks_classes") }}'
      "base.customers"                    : '{{ ref("quickbooks_customers") }}'
      "base.deposits_line"                : '{{ ref("quickbooks_deposit_lines") }}'
      "base.deposits_line_linkedtxn"      : '{{ ref("quickbooks_deposit_line_transactions") }}'
      "base.deposits"                     : '{{ ref("quickbooks_deposits") }}'
      "base.invoices_lines"               : '{{ ref("quickbooks_invoice_lines") }}'
      "base.invoices"                     : '{{ ref("quickbooks_invoices") }}'
      "base.items"                        : '{{ ref("quickbooks_items") }}'
      "base.journal_entries"              : '{{ ref("quickbooks_journal_entries") }}'
      "base.journal_entries_line"         : '{{ ref("quickbooks_journal_entry_lines") }}'
      "base.payments"                     : '{{ ref("quickbooks_payments") }}'
      "base.purchases_line"               : '{{ ref("quickbooks_purchase_lines") }}'
      "base.purchases"                    : '{{ ref("quickbooks_purchases") }}'
      "base.vendors"                      : '{{ ref("quickbooks_vendors") }}'
      "level_0_id_field"                  : "level_id"
      "source_key_id_field"               : "source_key"

profile: "contactually"

# repositories:
#  - "https://github.com/fishtown-analytics/quickbooks.git@v0.1.0"