The Jira user IDs are displaying in Snowflake instead of the users' names.

[Lakshmi CH]

Hi Team,

We are looking at the Jira data coming to Snowflake. Do you know why the tickets in the JIRA database display user IDs in the format "JIRAUSERXXXX" instead of the actual usernames? While the actual usernames are visible when we open the ticket in the browser, they appear as IDs in Snowflake. Can you please provide some suggestions on this?


Using this query : 

SELECT * FROM PROD_PROVISIONING.JIRA.ISSUE_RECENT WHERE ISSUE_KEY ='TEST-376629'

[Marc - Devoteam · Accepted solution]

Hi @Lakshmi CH 

This is the intended change from Atlassian after Jira version 8.2 due to the GDPR compliance policy.

More details can be found on below document

https://confluence.atlassian.com/jiracore/gdpr-changes-in-jira-975041009.html

The username and user-key should be same for users were created on a prior Jira release(before 8.2), so you are seeing the difference in the username and user_key for only those users that have been created after upgrading to a higher release.