Issue

While attempting to join Jira users to data such as projects and issues, it's not possible to join with the user_id.

Environment

Connector: Jira

Resolution

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, please raise a ticket with the Fivetran Support team.