# on\_schema\_change set to sync\_all\_columns throws error 'invalid identifier column' when new column added for incremental model

**URL:** <https://discourse.getdbt.com/t/on-schema-change-set-to-sync-all-columns-throws-error-invalid-identifier-column-when-new-column-added-for-incremental-model/14607>\
**Category:** Help\
**Created:** [July 31, 2024, 12:44pm UTC](https://discourse.getdbt.com/t/on-schema-change-set-to-sync-all-columns-throws-error-invalid-identifier-column-when-new-column-added-for-incremental-model/14607 "2024-07-31T12:44:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ambreen2912](https://avatars.discourse-cdn.com/v4/letter/a/df705f/32.png) [@ambreen2912](https://discourse.getdbt.com/u/ambreen2912)\
**Post date:** [July 31, 2024, 12:44pm UTC](https://discourse.getdbt.com/t/on-schema-change-set-to-sync-all-columns-throws-error-invalid-identifier-column-when-new-column-added-for-incremental-model/14607/1 "2024-07-31T12:44:05Z")

</div>

## I am configuring my incremental model to add new columns to the model without a full refresh. **I am getting an error ‘invalid identifier column’**. Note that these model are written in Snowflake through dbt. I am using on\_schema\_change=‘sync\_all\_columns’ in the configs.

## what i basically want is the incremental model to run without a full refresh and append and drop columns automatically, for new columns the historical values can be blank but the new values should populate

## I am using the following configs in the .yml and .sql files respectively:

```auto
name: audit_table
    description: >
      'some description and context'
    config:
      on_schema_change: "sync_all_columns"

    columns:
      - name: col

```

```auto
{{
    config(
        materialized='incremental',
        unique_key='date',
        on_schema_change='sync_all_columns',
        full_refresh=false
        
  )
}}

```

---

<div class="post-metadata">

**Author:** ![alih](https://avatars.discourse-cdn.com/v4/letter/a/50afbb/32.png) [@alih](https://discourse.getdbt.com/u/alih)\
**Post date:** [August 19, 2024, 2:26pm UTC](https://discourse.getdbt.com/t/on-schema-change-set-to-sync-all-columns-throws-error-invalid-identifier-column-when-new-column-added-for-incremental-model/14607/2 "2024-08-19T14:26:57Z")

</div>

Hi,  
I have a similar issue, I work with dbt core in combination with MS SQL Server. I get an ‘invalid column name’ when I run my model that has on\_schema\_change=‘sync\_all\_columns’ in the configs. It seems that the syncing just does not take place.  
Unfortunately I also did not find a solution yet. Does this maybe only work with dbt cloud?  
Happy for input. Thank you!