Delete rows in Incremental Model

Help
1

How to remove deleted rows in an incremental model?

Hello !

I am implemeting an incremental dbt model in BigQuery with :

  • created_date as partition
  • id as unique_key

I have a field named is_deleted which is set as TRUE if the record is deleted in raw table. I want to remove all the rows in my table where is_deleted is TRUE.

Any ideas how to do this ? Thanks !

2

you can do post hook .
where is_deletes=‘True’

3

What type of incremental update is it? Merge or insert_overwrite?