How to Join on the
Updated 11 days ago
You want to join Jira user data to other data (like project data and issue data), but joining on the
id does not work.
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.
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
To learn more, see our Jira ERDs.