Assets History
The Assets History additional export populates 1 table in Snowflake1:
Table Details
S4J_ASSETS_HISTORY
This table contains information related to Asset history in Jira. All Asset history information available from Jira is stored in this table. One instance of this table is created per configured export location. All exports with the Assets History additional export option selected will merge asset history 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. Custom/scheduled updates to exports will only merge in history entries that have changed since the last update.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
ASSETID | VARCHAR | Asset ID |
WORKSPACEID | VARCHAR | Asset’s workspace ID |
GLOBALID | VARCHAR | Asset’s global ID |
HISTORYID | INT | Asset history ID in Jira |
USERKEY | VARCHAR | Account ID for Jira user who changed the asset |
AFFECTEDATTRIBUTE | VARCHAR | Affected attribute |
OLDVALUE | VARCHAR | Original value of attribute |
NEWVALUE | VARCHAR | Updated value of attribute |
TYPE | INT | Asset history type |
CREATED | DATETIME | Timestamp for when the attribute was changed |
1This additional export option’s data references Assets. For this reason, the table(s) populated by the Assets export option will also be populated by this option. See the Assets export option tables for more information.