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