Edit on GitHubHow to Join on the
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.