[Bug] int_jira__issue_type_parent compilation error

Is there an existing issue for this?

[X] I have searched the existing issues

Describe the issue

Within the int_jira__issue_type_parents model we perform a coalesce and join in order to associate issues with epics. This works fine for next gen projects. However, if a user is leveraging a classic project then the reference is associated using the epic link. This can cause an issue in the join because we are specifically creating the epic_issue_id the int_jira__issue_epic model as an integer. Although it is clear that this is not always going to be an integer since classic projects will have this be a link.

Therefore, we need to update the following lines to cast the fields as strings to avoid this error:

The creation of the epic_issue_id needs to be cast as a string.
When we coalesce parent_issue_id and epic_issue_id we need to ensure both are strings.
For good measure we should also cast the join keys in the final cte as strings to ensure there is no error.

Relevant error log or model output

SQL Error [100038] [22018]: Numeric value 'https://ulr-here/epic-key' is not recognized

Expected behavior

The models can succeed regardless of next gen or classic Jira projects

dbt Project configurations

Quickstart

Package versions

Latest

What database are you using dbt with?

snowflake

dbt Version

1.7.1

Additional Context

No response

Are you willing to open a PR to help address this issue?

[X] Yes.
[ ] Yes, but I will need assistance and will schedule time during our office hours for guidance
[ ] No.

fivetran / dbt_jira