[Bug] dbt/quickbooks package breaking on build due to non-numerical sales_item_item_id about dbt_quickbooks_source HOT 5 CLOSED

The logs are from a previous run, before I had a few other packages installed and before I updated dbt to 1.0.3. However, updating to 1.0.3 did not resolve the issue, so I included the more recent version info reflect my current configuration.

from dbt_quickbooks_source.

Below is a list of what I believe to be affected models.

(dbt-env) evan@evan-XPS-15-9500:~/code/dbt/my-transformations/my_transformations/dbt_packages$ grep -r 'cast(sales_item_item' | grep -v '"'
quickbooks_source/models/stg_quickbooks__sales_receipt_line.sql: cast(sales_item_item_id as {{ dbt_utils.type_int() }}) as sales_item_item_id,
quickbooks_source/models/stg_quickbooks__invoice_line_bundle.sql: cast(sales_item_item_id as {{ dbt_utils.type_int() }}) as sales_item_item_id,
quickbooks_source/models/stg_quickbooks__invoice_line.sql: cast(sales_item_item_id as {{ dbt_utils.type_int() }}) as sales_item_item_id,
quickbooks_source/models/stg_quickbooks__credit_memo_line.sql: cast(sales_item_item_id as {{ dbt_utils.type_int() }}) as sales_item_item_id,
quickbooks_source/models/stg_quickbooks__refund_receipt_line.sql: cast(sales_item_item_id as {{ dbt_utils.type_int() }}) as sales_item_item_id,

from dbt_quickbooks_source.

@evancole-untitled I just made a few changes and see the error is resolved on my end. Would you be able to try the following branch of the Quickbooks package and let me know if you still see the error.

packages:
  - git: https://github.com/fivetran/dbt_quickbooks.git
    revision: bugfix/evancole-untitled-casting
    warn-unpinned: false

from dbt_quickbooks_source.

After adjusting the account_name within the int_quickbooks__retained_earnings model, we noticed the issue resolved itself.

I will be making a few last minute updates to the package and will be preparing it for review. Once it is approved during the review phase we will plan to merge this into the next release!

from dbt_quickbooks_source.

@evancole-untitled this issue will now be resolved in the latest version of the dbt_quickbooks v0.5.0 release! You can expect this release to be live at the top of the hour. Thank you again for all your help on pushing this bugfix along!

Feel free to open another issue if you encounter any errors, or open a FR if you would like to see more functionality from the package 😄

from dbt_quickbooks_source.