Users
The Users additional export populates 1 table in Snowflake:
Table Details
S4J_USERS
This table contains information related to users in Jira. All user information available from Jira is stored in this table. One instance of this table is created per configured export location. All exports with the Users additional export option selected will merge user 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 |
ACCOUNTID | VARCHAR | User account ID in Jira |
ACCOUNTTYPE | VARCHAR | User account type in Jira |
EMAILADDRESS | VARCHAR | User email address in Jira1 |
DISPLAYNAME | VARCHAR | User display name in Jira |
ACTIVE | BOOLEAN | Flag indicating whether user is active |
TIMEZONE | VARCHAR | User timezone in Jira1 |
LOCALE | VARCHAR | User locale in Jira1 |
1GDPR and Jira configuration allow users to prevent sharing of this information, which may hide this information in Jira’s API responses. Consequently, this information may not be available for all Jira users.