ISSUE_FIELD_HISTORY - Githubissues

maliro commented 1 month ago

Is there an existing issue for this?

[X] I have searched the existing issues

Describe the issue

We upgrade the Jira fivetran package to 017 in dbt. ISSUE_FIELD_HISTORY query fails after running over than 2 hours on snowflake warehouse : size XXL. Could we please set a meeting? I will appreciate your advice.

Relevant error log or model output

dbt command failed13:57:48 48 of 59 ERROR creating sql incremental model dwh_jira_cloud_cx.jira__daily_issue_field_history  [ERROR in 7201.90s]

13:57:48  Completed with 1 error and 0 warnings:
13:57:48  
13:57:48  Database Error in model jira__daily_issue_field_history (models/jira__daily_issue_field_history.sql)
13:57:48    000630 (57014): Statement reached its statement or warehouse timeout of 7,200 second(s) and was canceled.
13:57:48    compiled Code at target/run/jira/models/jira__daily_issue_field_history.sql

Expected behavior

I expect that this query will finish to run. size warehouse xxl is very big there is no reason why it is failing version 15 of Jira package did succeed.

dbt Project configurations

packages:

package: fivetran/jira version: 0.17.0

Package versions

version: 0.17.0

What database are you using dbt with?

snowflake

dbt Version

dbt v1.5.0-latest

Additional Context

/

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

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

fivetran-reneeli commented 1 month ago

Hi @maliro thanks for opening this. My thinking is this may be caused by recent updates we made to the incremental logic in the models. I think it would be helpful to debug this live; here is a booking link! Looking forward to speaking soon!