How to handle dbt model when new column(s) are added manually in the DB with default value.

I have added new columns in my snowflake table with default value of 0. When running the incremental model , I am now getting the error ‘invalid identifier colxx’ . This is because dbt builts merge based on target table definition and this column is not present in my model. Is there a way to handle this with some model configuration so I can avoid adding the unused columns in my dbt model?

1 Like