[Bug] Incompatible join condition within recharge__billing_history

[fivetran-joemarkiewicz]

Is there an existing issue for this?

• I have searched the existing issues

Describe the issue

It seems that in some cases there can be an error in the recharge__billing_history model where a join condition is not working as expected. In fact it seems that one of the datatypes is interpreted as a boolean. We can likely address this issue by ensuring all fields which we decide to join on are of the same datatype. This should likely be done at the staging model level. We should trace back the fields we join on and ensure the datatypes are consistent at the staging model layer.

Relevant error log or model output

Database Error in model recharge__billing_history (models/recharge__billing_history.sql)
No matching signature for operator = for argument types: INT64, BOOL

Input types for : {INT64, BOOL} at [57:23]

Expected behavior

The model is able to run as expected and the datatypes for joins are consistent.

Possible solution

See my note in the description.

dbt Project configurations

Default

Package versions

Latest

What database are you using dbt with?

bigquery

How are you running this dbt package?

Fivetran Quickstart Data Model

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.

[fivetran-jamie]

This has been tied back to a connector issue. We will close this out once that is resolved within Fivetran