Assets
The Assets additional export populates 3 tables in Snowflake:
Table Details
S4J_ASSETS
This table contains information related to Assets in Jira. All Asset 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 additional export option selected will merge asset 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 assets 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 |
OBJECTKEY | VARCHAR | Asset object key |
LABEL | VARCHAR | Asset label |
CREATED | DATETIME | Asset creation timestamp |
UPDATED | DATETIME | Asset update timestamp |
TYPEID | VARCHAR | Asset type ID |
TYPENAME | VARCHAR | Asset type name |
TYPEDESCRIPTION | VARCHAR | Asset type description |
TYPESCHEMAID | VARCHAR | Asset type schema ID |
S4J_ASSETS_BRIDGE
This table contains information that associates assets to work items and custom fields in Jira. All Asset custom field link information associated with the current export’s work items is stored in this table. One instance of this table is created per configured export location. All exports, regardless of Assets additional export option selection, will merge information into this table if they contain custom fields that use assets. For this reason, multiple exports per location may include this information without causing export processes to perform duplicate work. If all asset custom fields from Jira are required, then one or more exports containing all Jira work items must include these fields. Custom/scheduled updates to exports will only merge in information that has changed since the last update.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
ISSUEID | INT | Jira work item ID containing assets field |
FIELDID | VARCHAR | Jira field ID containing assets |
ASSETGLOBALID | VARCHAR | Asset’s global ID |
S4J_ASSETS_OBJECT_SCHEMAS
This table contains information related to Asset object schemas in Jira. All Asset object schema 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 additional export option selected will merge asset object schema 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 object schemas that have changed since the last update.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
WORKSPACEID | VARCHAR | Object schema’s workspace ID |
GLOBALID | VARCHAR | Object schema’s global ID |
SCHEMAID | VARCHAR | Object schema ID |
NAME | VARCHAR | Object schema name |
SCHEMAKEY | VARCHAR | Object schema key |
STATUS | VARCHAR | Object schema status |
DESCRIPTION | VARCHAR | Object schema description |
CREATED | DATETIME | Object schema creation timestamp |
UPDATED | DATETIME | Object schema update timestamp |
OBJECTCOUNT | INT | Number of objects in the schema |
OBJECTTYPECOUNT | INT | Number of object types in the schema |
CANMANAGE | BOOLEAN | Flag indicating whether the schema can be managed |
1This table is created and populated based on the presence of certain custom field selections in the main export table. The table may not exist in your Snowflake instance.