[Bug] Invalid Identifier Error

[fivetran-joemarkiewicz]

Is there an existing issue for this?

• I have searched the existing issues

Describe the issue

For some reason it seems that when deployed to Quickstart users will start to unexpectedly see an error at the staging model layer indicating an invalid identifier. This seems to only happen when the staging model is not present and an empty table is created.

Relevant error log or model output

invalid identifier '_FIVETRAN_SYNCED'

Expected behavior

The staging models are able to succeed regardless of the upstream source being present and to not throw the invalid identifier error.

Possible solution

I'm not entirely sure what the possible solution is, but it surely arises in the staging models and needs to be addressed there.

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 Core™

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.