dbt_salesforce/dbt_project.yml at main · fivetran/dbt_salesforce · 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
config-version: 2
name: 'salesforce'
version: '2.2.0'
require-dbt-version: [">=1.3.0", "<3.0.0"]
models:
  salesforce:
    +materialized: table
    intermediate:
      +materialized: ephemeral
    salesforce:
      staging:
        +materialized: table
    salesforce_history:
      staging:
        +materialized: table

vars:
  salesforce:
    account: "{{ source('salesforce', 'account') }}"
    opportunity: "{{ source('salesforce', 'opportunity') }}"
    user: "{{ source('salesforce', 'user') }}"
    user_role: "{{ source('salesforce', 'user_role') }}"
    contact: "{{ source('salesforce', 'contact') }}"
    lead: "{{ source('salesforce', 'lead') }}"
    task: "{{ source('salesforce', 'task') }}"
    event: "{{ source('salesforce', 'event') }}"
    product_2: "{{ source('salesforce', 'product_2') }}"
    order: "{{ source('salesforce', 'order') }}"
    opportunity_line_item: "{{ source('salesforce', 'opportunity_line_item') }}"

    account_history: "{{ source('salesforce_history', 'account') }}"
    contact_history: "{{ source('salesforce_history', 'contact') }}"
    opportunity_history: "{{ source('salesforce_history', 'opportunity') }}"


    salesforce__account_pass_through_columns: []
    salesforce__contact_pass_through_columns: []
    salesforce__event_pass_through_columns: []
    salesforce__lead_pass_through_columns: []
    salesforce__opportunity_pass_through_columns: []
    salesforce__opportunity_line_item_pass_through_columns: []
    salesforce__order_pass_through_columns: []
    salesforce__product_2_pass_through_columns: []
    salesforce__task_pass_through_columns: []
    salesforce__user_role_pass_through_columns: []
    salesforce__user_pass_through_columns: []

clean-targets:
- target
- dbt_modules
- dbt_packages