How to Join on the USER Tablelink

Updated 11 days ago

Use Caselink

You want to join Jira user data to other data (like project data and issue data), but joining on the id does not work.

Recommendationslink

Do not join the USER table on the id. Instead, join on the username to your target table's user_id. This includes tables in Fivetran's ERDs where the username is not specified as a primary key.

NOTE: Contact support if the username value isn't populated.

Contextlink

Fivetran ingests data from both Jira Cloud and Jira On-Premise. However, Fivetran's ERDs are specific to Jira Cloud only. In Jira On-Premise, an id is available but can't be joined with the USER table. However, you can use the username to join tables instead of the id.

To learn more, see our Jira ERDs.