# How to select only required columns to insert in dbt model

**URL:** <https://discourse.getdbt.com/t/how-to-select-only-required-columns-to-insert-in-dbt-model/4270>\
**Category:** Archive\
**Created:** [April 27, 2022, 1:20pm UTC](https://discourse.getdbt.com/t/how-to-select-only-required-columns-to-insert-in-dbt-model/4270 "2022-04-27T13:20:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![raviteja.u](https://avatars.discourse-cdn.com/v4/letter/r/b9bd4f/32.png) [@raviteja.u](https://discourse.getdbt.com/u/raviteja.u)\
**Post date:** [April 27, 2022, 1:20pm UTC](https://discourse.getdbt.com/t/how-to-select-only-required-columns-to-insert-in-dbt-model/4270/1 "2022-04-27T13:20:58Z")

</div>

How to select and insert required column in dbt model.  
I have a column called “ID” which is an autoincrement and i dont want to select and insert this column value to snowflake db. is this possible to exclude columns in the insert sqL of a model.

---

<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 2, 2022, 10:54pm UTC](https://discourse.getdbt.com/t/how-to-select-only-required-columns-to-insert-in-dbt-model/4270/2 "2022-08-02T22:54:13Z")

</div>

Hey man!

Were you able to resolve that? I’m having the same issue.