invalidate_hard_deletes
▶Changelog
snapshots/<filename>.sql
{{config(strategy="timestamp",invalidate_hard_deletes=True)}}
dbt_project.yml
Description
Opt-in feature to enable invalidating hard deleted records while snapshotting the query.
Default
By default the feature is disabled.
Example
snapshots/orders.sql
{% snapshot orders_snapshot %}{{config(target_schema='snapshots',strategy='timestamp',unique_key='id',updated_at='updated_at',invalidate_hard_deletes=True,)}}select * from {{ source('jaffle_shop', 'orders') }}{% endsnapshot %}