Add missing initial values in jira_issue_history_change_item or provide access to the enhanced JiraIssueHistory table in the Data Share Schema

XMLWordPrintable

      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

      1. Include the initial value of the Jira issue in jira_issue_history_change_item
      2. 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.

            Assignee:
            Tina Ling
            Reporter:
            Matthew Lempitsky
            Votes:
            8 Vote for this issue
            Watchers:
            13 Start watching this issue

              Created:
              Updated: