-
Suggestion
-
Resolution: Unresolved
-
None
User Problem
Currently in the Atlassian Data Share schema, only the jira_issue_history_change_item is exposed. This table does not include the initial values of a Jira Issue.
Suggested Solutions
- Include the initial value of the Jira issue in jira_issue_history_change_item
- Less optimal option, as this would result in data freshness from 5-8 hours and not work for all use cases. In the Atlassian Data Lake, the jira_issue_history table is an enhanced model that pulls the initial values from the jira_issue_field table.
Current Workarounds
It is currently possible to construct this manually in the Delta Share schema, leveraging the jira_issue_change_item table and the Jira_issue_field table. This is not a trivial task, so it would be convenient to expose the enhanced table in the Data Share schema as well.