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'