Skip to main content

invalidate_hard_deletes

Changelog
snapshots/<filename>.sql
{{
config(
strategy="timestamp",
invalidate_hard_deletes=True
)
}}

dbt_project.yml
snapshots:
<resource-path>:
+strategy: timestamp
+invalidate_hard_deletes: true

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 %}