# delete a row in incremental model

**URL:** <https://discourse.getdbt.com/t/delete-a-row-in-incremental-model/8604>\
**Category:** Help\
**Tags:** incremental\
**Created:** [June 6, 2023, 11:24pm UTC](https://discourse.getdbt.com/t/delete-a-row-in-incremental-model/8604 "2023-06-06T23:24:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![soumitra.mehrotra9](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/soumitra.mehrotra9/32/2509_2.png) [@soumitra.mehrotra9](https://discourse.getdbt.com/u/soumitra.mehrotra9)\
**Post date:** [June 6, 2023, 11:24pm UTC](https://discourse.getdbt.com/t/delete-a-row-in-incremental-model/8604/1 "2023-06-06T23:24:33Z")

</div>

Hi folks, I have an incremental dbt model that uses a delete+insert strategy for a certain `unique key` called **ID**. There is also a boolean column called **is\_deleted** in the model. For the **ID** , If the updated value of **is\_deleted** column is updated to True, I want to delete the row corresponding to the ID and not insert/update it. Any advice on how can I achieve this? I’d really appreciate any help you can provide. Thanks

---

<div class="post-metadata">

**Author:** ![Surya](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/surya/32/3763_2.png) [@Surya](https://discourse.getdbt.com/u/Surya)\
**Post date:** [June 7, 2023, 8:45am UTC](https://discourse.getdbt.com/t/delete-a-row-in-incremental-model/8604/2 "2023-06-07T08:45:04Z")

</div>

> [@soumitra.mehrotra9](#):
>
> **is\_deleted**

@soumitra.mehrotra9 could you please confirm that the **is\_deleted** field is available in the source model or in the target model(incremental model)