[Bug] Correct Zendesk URL

[fivetran-joemarkiewicz]

Is there an existing issue for this?

• I have searched the existing issues

Describe the issue

The url provided natively within the Ticket staging model is not a "clickable" url. We should update the Zendesk url to be built so it's a clickable url to be referenced.

Relevant error log or model output

The url is not clickable

Expected behavior

We build the url in such a way that it is able to be a fully clickable url link

Possible solution

We can leverage the same field we already are using however we remove the .json from the string.

dbt Project configurations

Default

Package versions

Latest

What database are you using dbt with?

postgres, redshift, snowflake, bigquery, databricks

How are you running this dbt package?

Fivetran Quickstart Data Model, Fivetran Transformations, dbt Core™, dbt Cloud™

dbt Version

Latest

Additional Context

No response

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

• Yes.
• Yes, but I will need assistance.
• No.