Connector Improvement: Jira - Custom Sprint Field
Hi there,
We're using the jira<>Bigquery connector and trying to relate issues to specific sprints. The trouble is that some of our issues span multiple sprints (e.g. an issue is created in sprint 1, but carries over and is completed in sprint 2). The field in jira encapsulates this by showing the additional sprints that an issue was a part of.
When I look for values for this field (customfield_10007, in our case) in the tables (issue_field_history) synced from Fivetran, I'm not finding anything. Presumably it's not synced because this data isn't easily represented as a string, integer, etc. Could this be improved somehow? Maybe handled in the same way that nested JSON (arrays) are represented as strings?
Despite the custom field, to my knowledge we're using the default configuration for a Sprint field in jira. I could be missing something here, so please let me know, but having the sprint field sync properly would help us out greatly.
Thanks!
-
Official comment
Hi Julian -
Thanks for submitting this feature request. You should be able to get this information actually already from the data we provide. We have a dbt package even modeling this!
I would recommend you use the output of our jira_daily_field_history model.
Best,
Erin
Please sign in to leave a comment.
Comments
1 comment