dbt_jira/integration_tests/dbt_project.yml at e9decd0550850424980e72d01e65b0ffd462b7e6 · fivetran/dbt_jira · 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
name: 'jira_integration_tests'
version: '1.1.0'
config-version: 2
profile: 'integration_tests'


vars:
  jira_using_components: false

 # Comment out the below when generating docs
  issue_field_history_columns: ['summary', 'components','team' ,'project']  # @docs-ignore

  jira:
    jira_schema: jira_integrations_tests_42
    jira_comment_identifier: "comment"
    jira_component_identifier: "component"
    jira_epic_identifier: "epic"
    jira_field_identifier: "field"
    jira_field_option_identifier: "field_option"
    jira_issue_field_history_identifier: "issue_field_history"
    jira_issue_link_identifier: "issue_link"
    jira_issue_multiselect_history_identifier: "issue_multiselect_history"
    jira_issue_type_identifier: "issue_type"
    jira_issue_identifier: "issue"
    jira_priority_identifier: "priority"
    jira_project_board_identifier: "project_board"
    jira_project_category_identifier: "project_category"
    jira_project_identifier: "project"
    jira_resolution_identifier: "resolution"
    jira_sprint_identifier: "sprint"
    jira_status_category_identifier: "status_category"
    jira_status_identifier: "status"
    jira_user_group_identifier: "user_group"
    jira_user_identifier: "user"
    jira_version_identifier: "version"
    jira_team_identifier: "team"


models:
  jira:
    +schema: "{{ 'jira_integrations_tests_sqlw' if target.name == 'databricks-sql' else 'jira' }}"
    # +schema: "jira_{{ var('directed_schema','dev') }}"

seeds:
  +docs:
    show: False
  jira_integration_tests:
    +column_types:
      _fivetran_synced: timestamp
    comment:
      +column_types:
        id: "{{ 'int64' if target.name == 'bigquery' else 'bigint' }}"
        created: timestamp
        issue_id: "{{ 'int64' if target.name == 'bigquery' else 'bigint' }}"
        updated: timestamp
    component:
      +column_types:
        id: "{{ 'int64' if target.name == 'bigquery' else 'bigint' }}"
        project_id: "{{ 'int64' if target.name == 'bigquery' else 'bigint' }}"
    epic:
      +column_types:
        id: "{{ 'int64' if target.name == 'bigquery' else 'bigint' }}"
    field_option:
      +column_types:
        id: "{{ 'int64' if target.name == 'bigquery' else 'bigint' }}"
    issue:
      +column_types:
        id: "{{ 'int64' if target.name == 'bigquery' else 'bigint' }}"
        created: timestamp
        work_ratio: float
        resolved: timestamp
        updated: timestamp
        assignee: "{{ 'string' if target.name in ('bigquery', 'spark', 'databricks', 'databricks-sql') else 'varchar' }}"
    issue_multiselect_history:
      +column_types:
        time: timestamp
        issue_id: "{{ 'int64' if target.name == 'bigquery' else 'bigint' }}"
        value: "{{ 'string' if target.name in ('bigquery', 'spark', 'databricks', 'databricks-sql') else 'varchar' }}"
    issue_field_history:
      +column_types:
        time: timestamp
        issue_id: "{{ 'int64' if target.name == 'bigquery' else 'bigint' }}"
        value: "{{ 'string' if target.name in ('bigquery', 'spark', 'databricks', 'databricks-sql') else 'varchar' }}"
    sprint:
      +column_types:
        id: "{{ 'int64' if target.name == 'bigquery' else 'bigint' }}"
        complete_date: timestamp
        end_date: timestamp
        start_date: timestamp
    field:
      +column_types:
        id: "{{ 'string' if target.name in ('bigquery', 'spark', 'databricks', 'databricks-sql') else 'varchar' }}"

dispatch:
  - macro_namespace: dbt_utils
    search_order: ['spark_utils', 'dbt_utils']

flags:
  send_anonymous_usage_stats: False
  use_colors: True