dbt_hubspot/dbt_project.yml at c7a16b20b113919ff2bba153d0c748e7fba66bf7 · fivetran/dbt_hubspot · 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
name: 'hubspot'
version: '1.8.0'

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

vars:
  hubspot:
    company: "{{ source('hubspot','company') }}"
    company_property_history: "{{ source('hubspot','company_property_history') }}"
    contact: "{{ source('hubspot','contact') }}"
    contact_form_submission: "{{ source('hubspot','contact_form_submission') }}"
    contact_merge_audit: "{{ source('hubspot','contact_merge_audit') }}"
    contact_list: "{{ source('hubspot','contact_list') }}"
    contact_list_member: "{{ source('hubspot','contact_list_member') }}"
    contact_property_history: "{{ source('hubspot','contact_property_history') }}"
    deal: "{{ source('hubspot','deal') }}"
    deal_stage: "{{ source('hubspot','deal_stage') }}"
    deal_company: "{{ source('hubspot','deal_company') }}"
    deal_contact: "{{ source('hubspot','deal_contact') }}"
    deal_pipeline: "{{ source('hubspot','deal_pipeline') }}"
    deal_pipeline_stage: "{{ source('hubspot','deal_pipeline_stage') }}"
    deal_property_history: "{{ source('hubspot','deal_property_history') }}"
    merged_deal: "{{ source('hubspot','merged_deal') }}"
    email_campaign: "{{ source('hubspot','email_campaign') }}"
    email_event: "{{ source('hubspot','email_event') }}"
    email_event_bounce: "{{ source('hubspot','email_event_bounce') }}"
    email_event_click: "{{ source('hubspot','email_event_click') }}"
    email_event_deferred: "{{ source('hubspot','email_event_deferred') }}"
    email_event_delivered: "{{ source('hubspot','email_event_delivered') }}"
    email_event_dropped: "{{ source('hubspot','email_event_dropped') }}"
    email_event_forward: "{{ source('hubspot','email_event_forward') }}"
    email_event_open: "{{ source('hubspot','email_event_open') }}"
    email_event_print: "{{ source('hubspot','email_event_print') }}"
    email_event_sent: "{{ source('hubspot','email_event_sent') }}"
    email_event_spam_report: "{{ source('hubspot','email_event_spam_report') }}"
    email_event_status_change: "{{ source('hubspot','email_event_status_change') }}"
    engagement: "{{ source('hubspot','engagement') }}"
    engagement_call: "{{ source('hubspot','engagement_call') }}"
    engagement_communication: "{{ source('hubspot','engagement_communication') }}"
    engagement_company: "{{ source('hubspot','engagement_company') }}"
    engagement_contact: "{{ source('hubspot','engagement_contact') }}"
    engagement_deal: "{{ source('hubspot','engagement_deal') }}"
    engagement_email: "{{ source('hubspot','engagement_email') }}"
    engagement_meeting: "{{ source('hubspot','engagement_meeting') }}"
    engagement_note: "{{ source('hubspot','engagement_note') }}"
    engagement_task: "{{ source('hubspot','engagement_task') }}"
    form: "{{ source('hubspot','form') }}"
    owner: "{{ source('hubspot','owner') }}"
    owner_team: "{{ source('hubspot','owner_team') }}"
    property: "{{ source('hubspot','property') }}"
    property_option: "{{ source('hubspot','property_option') }}"
    role: "{{ source('hubspot','role') }}"
    team: "{{ source('hubspot','team') }}"
    team_user: "{{ source('hubspot','team_user') }}"
    ticket_company: "{{ source('hubspot','ticket_company') }}"
    ticket_contact: "{{ source('hubspot','ticket_contact') }}"
    ticket_deal: "{{ source('hubspot','ticket_deal') }}"
    ticket_engagement: "{{ source('hubspot','ticket_engagement') }}"
    ticket_pipeline: "{{ source('hubspot','ticket_pipeline') }}"
    ticket_pipeline_stage: "{{ source('hubspot','ticket_pipeline_stage') }}"
    ticket_property_history: "{{ source('hubspot','ticket_property_history') }}"
    ticket: "{{ source('hubspot','ticket') }}"
    users: "{{ source('hubspot','users') }}"
    hubspot__deal_pass_through_columns: []
    hubspot__contact_pass_through_columns: []
    hubspot__company_pass_through_columns: []
    hubspot__ticket_pass_through_columns: []

models:
  hubspot:
    +materialized: table
    +schema: hubspot
    marketing:
      intermediate:
        +materialized: ephemeral
        int_hubspot__contact_merge_adjust:
          +materialized: table
    sales:
      intermediate:
        +materialized: ephemeral
        int_hubspot__deals_enhanced:
          +materialized: table
    staging:
      +materialized: table
      +schema: stg_hubspot
      tmp:
        +materialized: view