Uploaded image for project: 'Analytics'
  1. Analytics
  2. ANALYTICS-375

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

XMLWordPrintable

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      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.

              tling@atlassian.com Tina Ling
              304d9124595a Matthew Lempitsky
              Votes:
              8 Vote for this issue
              Watchers:
              13 Start watching this issue

                Created:
                Updated: