Sprints
The Sprints additional export populates 1 table in Snowflake:
Table Details
S4J_SPRINTS
This table contains information related to sprints in Jira. All sprint information available from Jira is stored in this table. One instance of this table is created per configured export location. All exports with the Sprints additional export option selected will merge sprint information into this table. For this reason, it is generally recommended that this option only be selected for one export per location. Otherwise export processes may perform duplicate work.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
SPRINTID | INT | Sprint ID in Jira |
NAME | VARCHAR | Sprint name in Jira |
STATE | VARCHAR | Sprint state in Jira |
GOAL | VARCHAR | Sprint goal in Jira |
CREATEDDATE | DATETIME | Sprint created timestamp in Jira |
STARTDATE | DATETIME | Sprint start timestamp in Jira |
ENDDATE | DATETIME | Sprint end timestamp in Jira |
BOARDID | ARRAY | IDs of boards associated with sprint in Jira |
ORIGINBOARDID | INT | Origin board ID for sprint in Jira |