Jira sprint and Jira Service Management request type data are available in data shares

[#1]

Exciting news! We’ve released Jira sprint data and Jira Service Management request type data in data shares.

• Sprint data is available in the table jira_sprint. Read more about the “Jira sprint” table.

• Request type data is available in the table jira_request_type. Read more about the "Request type" table.

How can I start using this data?

You won’t need to take any action. These new tables will automatically be added to your existing data shares.

To link issues to a sprint:

1. Find the sprint fields in the jira_issue_field table by filtering with name = 'Sprint'.
   The value column will contain an array with the sprint references.

2. You have two options to join with the jira_sprint table:

   1. On workspace_id and with value (array) and sprint_ref (single value)

   2. Recreating the jira_sprint.sprint_id using the jira_issue_field.value and jira_issue_field.workspace_id. The format of the sprint ID is workspace_id::sprint_ref

Looking for more?

Don’t hesitate to send us feedback on which data or features you want us to add next.

You can also vote on your most wanted requests for Atlassian Analytics, data shares, and the Atlassian Data Lake.

Let us know if you have any questions!

Claire Gayrard

Product Manager, Atlassian Data Lake

[Josh]

This is great news. Thank you, @Claire Gayrard