How to Join on the USER Table

Use Case

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

Recommendations

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.

Context

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.