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?
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
Config merge_exclude_columns acts only on merge not on insert | 0 | 2858 | October 3, 2023 | |
on_schema_change set to sync_all_columns throws error 'invalid identifier column' when new column added for incremental model | 1 | 192 | August 19, 2024 | |
Adding a column to an incremental model | 7 | 26212 | October 13, 2020 | |
Handling merge statements in incremental models | 2 | 12795 | July 23, 2019 | |
The incremental model is currently choosing columns that have not yet been selected. | 1 | 897 | February 8, 2024 |