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.