Postgres Adapter incremental strategy delete+insert is not deleting rows

The problem I’m having: dbt incremental model is not able to delete row in target table

The context of why I’m trying to do this: Trying to implement a SCD Type1 implementation. I have underlying Hub/satelite tables and using dbt vault package for that. I have to track change for a given dimension id and update the attribute value accordingly. As dbt does not support “merge” yet for postgres adapter the option is “delete+insert” strategy.

What I’ve already tried: Updated model configuration as followed:

materialized = ‘incremental’,
incremental_strategy = ‘delete+insert’

Some example code or error messages

{{
  config(
    materialized = 'incremental',
    unique_key = 'dim_id',
    incremental_strategy = 'delete+insert'
        
        
    )
}}