Components
The Components additional export populates 1 table in Snowflake:
Table Details
S4J_COMPONENTS
This table contains information related to project components in Jira. All component information available from Jira is stored in this table. One instance of this table is created per configured export location. All exports with the Components additional export option selected will merge component 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 |
COMPONENTID | INT | Component ID in Jira |
NAME | VARCHAR | Component name in Jira |
DESCRIPTION | VARCHAR | Component description in Jira |
ASSIGNEETYPE | VARCHAR | Component assignee type |
REALASSIGNEETYPE | VARCHAR | Component real assignee type |
ISASSIGNEETYPEVALID | BOOLEAN | Flag indicating whether assignee type is valid |
PROJECTKEY | VARCHAR | Associated Jira project key |
PROJECTID | INT | Associated Jira project ID |