[Bug] Incompatible datatypes in greenhouse__interview_enhanced joins

[fivetran-joemarkiewicz]

Is there an existing issue for this?

• I have searched the existing issues

Describe the issue

For some users there is the possibility of encountering the below provided error. This is likely a result of the joins in either the greenhouse__interview_enhanced end model or an upstream intermediate model not being compatible and therefore throwing the no matching signature error.

Relevant error log or model output

Database Error in model greenhouse__interview_enhanced (models/greenhouse__interview_enhanced.sql)
No matching signature for operator = for argument types: STRING, INT64. Supported signature: ANY = ANY at [184:12]
compiled Code at greenhouse__interview_enhanced.sql

Expected behavior

The end models are all expected to complete successfully and the datatypes of fields we're joining on are expected to be compatible.

Possible solution

We can either:

• Cast the fields within the joins themselves.
  • Easy solution, but not the ideal one.
• Cast the fields in the upstream staging models of dbt_greenhouse_source
  • The more time intensive solution, but the preferred option

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.