-
Notifications
You must be signed in to change notification settings - Fork 15
/
jira.yml
276 lines (272 loc) · 14.3 KB
/
jira.yml
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
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
version: 2
models:
- name: jira__daily_issue_field_history
description: >
Each record represents a snapshot of an issue's selected fields (as specified in
the `issue_history_columns` variable + sprint and status by default) on a given day.
Each issue will have a record for every day in which it was open and/or being updated.
For currently open issues, the latest date will be the current date, and for closed issues,
this will be the last time the issue was resolved OR updated in any way (plus a configurable buffer afterward,
set to a month by default).
Note: this is an incremental model.
columns:
- name: date_day
description: Date on which the issue had these field values.
- name: date_week
description: The start date of the week corresponding to `date_day`.
- name: issue_id
description: Foreign key referencing the ID of the `issue` with these values.
- name: issue_day_id
description: Surrogate key hashed on `date_day` and `issue_id`
tests:
- unique
- not_null
- name: sprint
description: The ID of the sprint that an issue is slotted into on a given day.
- name: status_id
description: The ID of the status that an issue has on a given day.
- name: status
description: The name of the status that an issue has on a given day.
# other fields included in var(issue_history_columns)
- name: jira__issue_enhanced
description: >
The core issue table, enhanced with current-status attributes from foreign-key-related tables,
and metrics regarding resolutions and assignments.
columns:
- name: issue_id
description: Unique ID of the issue.
tests:
- unique
- not_null
- name: issue_name
description: Title of the issue.
- name: updated_at
description: Timestamp of when the issue was last updated in some way.
- name: issue_type
description: Name of the issue type (ie Epic, Task, Subtask, any custom types).
- name: created_at
description: Timestamp of when the issue was created (in UTC).
- name: issue_description
description: The issue description, if given.
- name: due_date
description: Calendar day on which the issue is due, if a due date is provided.
- name: environment
description: Text field describing the environment in which the issue occurred (ie "IE9 on Windows 7").
- name: assignee_user_id
description: Foreign key referencing the ID of the `user` currently assigned to this task.
- name: assignee_name
description: User display name of the person currently assigned this issue.
- name: reporter_user_id
description: >
Foreign key referencing the ID of the `user` who reported the issue. This differs from the `issue.creator` column
in that the reporter can be changed in-app, though it is initialized as the creator.
- name: reporter_name
description: User display name of the person who reported the issue.
- name: assignee_timezone
description: Timezone of the user currently assigned this issue.
- name: assignee_email
description: Email associated with the user currently assigned this issue.
- name: issue_key
description: UI-facing id of the issue.
- name: parent_issue_id
description: Self-referencing ID of the parent `issue`.
- name: parent_issue_name
description: Title of the parent issue/epic.
- name: parent_issue_key
description: Issue key of the sub-issue's parent/epic.
- name: parent_issue_type
description: Name of the type of issue that the parent is.
- name: current_priority
description: Name of the issue's current priority as it appears in the UI.
- name: project_id
description: Foreign key referencing the `project` that the issue belongs to.
- name: project_name
description: Title of the issue's project.
- name: resolution_type
description: Display name of the type of resolution that closed the issue.
- name: resolved_at
description: >
Timestamp of when the issue was resolved (ie completed, marked as duplicate). If an issue
is un-resolved, this will be null.
- name: current_status
description: Title of the category of status.
- name: status_changed_at
description: Timestamp of when the status was last changed.
- name: current_sprint_id
description: Foreign key referencing the current `sprint` associate with the issue.
- name: current_sprint_name
description: Title of the current sprint associated with the issue.
- name: count_sprint_changes
description: The total number of sprints that the issue has belonged to.
- name: is_active_sprint
description: Yes, if the sprint started after the current time and if the sprint ends in the future.
- name: sprint_completed_at
description: Timestamp of when the sprint was completed.
- name: sprint_ended_at
description: Timestamp of when the sprint is planned to end.
- name: sprint_started_at
description: Timestamp of when the sprint began.
- name: sprint
description: List of associated sprint IDs.
- name: status
description: ID of the associated status.
- name: original_estimate_seconds
description: The original estimate of how long working on this issue would take, in seconds.
- name: remaining_estimate_seconds
description: The estimate of how much longer working on this issue will take, in seconds.
- name: time_spent_seconds
description: The time that was spent working on this issue, in seconds.
- name: work_ratio
description: >
The percentage of work that has been logged against the issue (time_spent) vs the original estimate of worktime.
Equals -1.0 when the fields required for calculation are not provided.
- name: conversation
description: >
Line-separated list of comments made on this issue, including the timestamp and author name of each comment.
(Disabled by default for Redshift.)
- name: count_comments
description: The number of comments made on this issues.
- name: first_assigned_at
description: Timestamp of when the issue was first assigned to a user.
- name: last_assigned_at
description: Timestamp of when the issue was last assigned to a user.
- name: first_resolved_at
description: Timestamp of when the issue was first resolved.
- name: open_duration_seconds
description: The number of seconds that the issue has spent open (until resolution, or the current timestamp).
- name: any_assignment_duration_seconds
description: The number of seconds that the issue has spent assigned (until resolution, or the current timestamp).
- name: last_assignment_duration_seconds
description: The number of seconds that the issue has spent assigned to the current/most recent user (until resolution, or the current timestamp).
- name: creator_user_id
description: Foreign key referencing the `user` who first created the issue. Cannot be changed.
- name: issue_type_id
description: Foreign key referencing the ID of the `issue_type`.
- name: priority_id
description: Foreign key referencing the ID of the issue's current `priority`.
- name: resolution_id
description: Foreign key referencing the ID of the issue's type of `resolution`.
- name: status_id
description: >
Foreign key referencing the ID of the issue's `status` (the step that the issue is currently at
in the project's workflow).
- name: is_parent_epic
description: Boolean that is true if the parent is an epic.
- name: reporter_email
description: Email associated with the user who reported this issue.
- name: reporter_timezone
description: Timezone of the user currently who reported this issue.
- name: affects_versions
description: Comma-separated list of the names of project versions that this issue affects.
- name: fixes_versions
description: Comma-separated list of the names of project versions that this issue fixes.
- name: current_status_category
description: Title of the umbrella status category that the issue is currently in.
- name: jira__project_enhanced
description: >
Table of projects enriched with data about its lead, epics, components, and volume and velocity of worktime.
columns:
- name: project_id
description: Unique ID of the project.
tests:
- unique
- not_null
- name: project_description
description: Description of the project, if given.
- name: project_key
description: UI-facing ID of the project. This becomes the default prefix for tasks created within this project.
- name: project_lead_user_id
description: Foreign key referencing the ID of the `user` who leads this project.
- name: project_name
description: Title of the project.
- name: permission_scheme_id
description: Foreign key referencing the ID of the `permission_scheme` that the project ascribes to.
- name: project_category_id
description: Foreign key referencing the ID of the `project_category` that the project is associated with, if any.
- name: project_lead_user_name
description: User display name of the person leading this project.
- name: project_lead_email
description: Email associated with the project lead.
- name: epics
description: Comma-separated list of epics worked on in this project.
- name: components
description: Comma-separated list of components of this project.
- name: count_closed_issues
description: The number of issues closed in this project.
- name: count_open_issues
description: The number of currently un-resolved issues in the project.
- name: count_open_assigned_issues
description: The number of currently open and currently assigned issues in the project.
- name: avg_close_time_seconds
description: The average time taken to close issues, in seconds.
- name: avg_assigned_close_time_seconds
description: The average time taken to close issues from their first assignment, in seconds.
- name: avg_age_currently_open_seconds
description: The average age of any currently-open issues.
- name: avg_age_currently_open_assigned_seconds
description: The average age of any currently-open issues, from their first assignment.
- name: median_close_time_seconds
description: The median time taken to close issues, in seconds.
- name: median_age_currently_open_seconds
description: The median age of any currently-open issues.
- name: median_assigned_close_time_seconds
description: The median time taken to close issues from their first assignment, in seconds.
- name: median_age_currently_open_assigned_seconds
description: The median age of any currently-open issues, from their first assignment.
- name: avg_close_time_days
description: The average time taken to close issues, in days.
- name: avg_assigned_close_time_days
description: The average time taken to close issues from their first assignment, in days.
- name: avg_age_currently_open_days
description: The average age of any currently-open issues.
- name: avg_age_currently_open_assigned_days
description: The average age of any currently-open issues, from their first assignment.
- name: median_close_time_days
description: The median time taken to close issues, in days.
- name: median_age_currently_open_days
description: The median age of any currently-open issues.
- name: median_assigned_close_time_days
description: The median time taken to close issues from their first assignment, in days.
- name: median_age_currently_open_assigned_days
description: The median age of any currently-open issues, from their first assignment.
- name: jira__user_enhanced
description: >
Table of users enriched with their projects, and the volume and velocity of their issues.
columns:
- name: user_id
description: Unique ID of the user.
tests:
- unique
- not_null
- name: email
description: Email associated with the user acccount.
- name: locale
description: The Java locale of the user.
- name: user_display_name
description: Name of the user as it appears in the UI.
- name: time_zone
description: The user's timezone, as defined in their settings.
- name: username
description: Account username.
- name: projects
description: Comma-separated list of projects on which the user has been assigned to.
- name: count_closed_issues
description: The number of issues that the user has closed (while being assigned to).
- name: count_open_issues
description: The number of currently open issues that the user is assigned to.
- name: avg_close_time_seconds
description: The average time taken to close issues since assignment, in seconds.
- name: avg_age_currently_open_seconds
description: Tjhe average age of a user's currently open issues.
- name: median_close_time_seconds
description: The median time taken to close issues since assignment, in seconds.
- name: median_age_currently_open_seconds
description: The median age of a user's currently open issues.
- name: avg_close_time_days
description: The average time taken to close issues since assignment, in days.
- name: avg_age_currently_open_days
description: The average age of a user's currently open issues.
- name: median_close_time_days
description: The median time taken to close issues since assignment, in days.
- name: median_age_currently_open_days
description: The median age of a user's currently open issues.