Casting To INT64 Line causing test failure

fivetran / dbt_jira

Data models for Fivetran's Jira connector built using dbt.

https://fivetran.github.io/dbt_jira/

Apache License 2.0

8 stars 13 forks source link

Casting To INT64 Line causing test failure #110

Closed KishGoh99 closed 9 months ago

KishGoh99 commented 10 months ago

We have a data product that brings in an external package - DBT FiveTran Jira but the line in the model below fails in our run instance because it is trying to cast a string value into an integer. I began to explore and it turns out our piece of data that offends the line is a URL link that can have a string value.

https://github.com/fivetran/dbt_jira/blob/688a1ab627d17784a0efa7cc0eb1fac861cec99b/models/intermediate/int_jira__issue_epic.sql#L15

Is there a way to disable this test? or modify the line to accept string values?

Thanks, Kishen

fivetran-catfritz commented 9 months ago

Hi @KishGoh99 thank you for submitting this issue. I am looking into this issue and have a question first. In your source data warehouse, do you have a jira table called epic? This is an optional table, and I'm wondering if it changes something our package does not anticipate.

In the meantime, there are a couple ways to turn off the test. You mentioned using a data product, so I'm not sure which would work best for you. Are you running dbt via CLI, cloud, or another way?

fivetran-catfritz commented 9 months ago

Hi @KishGoh99 just checking in if you were able to look into this?

KishGoh99 commented 9 months ago

Hi @fivetran-catfritz - Sorry for the delay. I'm afraid I haven't as priorities have moved on. For the time being, I'm going to close this ticket down and come back to you when I get a chance to look into it more. Thanks again.

andrew-karcher commented 5 months ago

@KishGoh99 - We are facing this error now as well. It started in the last couple weeks I think. Did you figure out any workaround? or @fivetran-catfritz did you find out anything?