[Jira] Why Can't I Join on user_id?

Use Case/Scenario:

You want to join Jira users to data such as projects and issues. You have read both of Fivetran’s Legacy and New Jira ERDs, but a join on the user_id does not work.

Fivetran Recommendation:

• Instead of joining from the USER table on user_id, join the USER table on username to your target table’s user_id
• This includes tales in Fivetran’s ERDs where the username is not specified as a key

Context:

• Fivetran supports the ingestion of data from both Jira Cloud and Jira On-Premise
• However, Fivetran’s ERDs are specific to Jira Cloud only
• In Jira On-Premise, where a user_id is not available the username can be used interchangeably to join tables

Considerations:

• Should you experience issues with joining tables using this method, then please raise a ticket with the Fivetran Support team