# Insert only specific columns with DBT

**URL:** <https://discourse.getdbt.com/t/insert-only-specific-columns-with-dbt/4700>\
**Category:** Archive\
**Created:** [August 3, 2022, 12:14pm UTC](https://discourse.getdbt.com/t/insert-only-specific-columns-with-dbt/4700 "2022-08-03T12:14:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![thiagobellotto](https://avatars.discourse-cdn.com/v4/letter/t/c37758/32.png) [@thiagobellotto](https://discourse.getdbt.com/u/thiagobellotto)\
**Post date:** [August 3, 2022, 12:14pm UTC](https://discourse.getdbt.com/t/insert-only-specific-columns-with-dbt/4700/1 "2022-08-03T12:14:25Z")

</div>

Hello all!

I’m having a problem with selecting and inserting in the dbt model.

I have a column called “ID” which is an autoincrement column, and I don’t want to select and insert this column value to Snowflake. The query in raw SQL would look like:

```auto
insert into final_table (name, age, created_at)
select *
from person_table

```

When I translate it to dbt, looks like this:

```auto
{{
    config(
        materialized = 'incremental'
    )
}}

with person_table as (
  select *
  from person_table
)

select
   name,
   age,
   created_at
from person_table

{% if is_incremental() %}
    AND created_at > (select max(created_at) from {{ this }})
{% endif %}

```

However, as you can see, I don’t want to INSERT INTO with the ID column, because whenever I create a new row, it is going to auto-generate the ID. In the compiled code, It keeps trying to insert all the columns from the table. So, is it possible to exclude some columns in the insert of dbt?

If feels like a super basic feature 😕