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

Lakshmi S
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 11, 2025

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'

snowflake.png

0 answers

Suggest an answer

Log in or Sign up to answer