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