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
@soumitra.mehrotra9 could you please confirm that the is_deleted field is available in the source model or in the target model(incremental model)