invalidate_hard_deletes

Use the hard_deletes config instead

Note, in Versionless and dbt Core 1.9 and higher, the hard_deletes config replaces the invalidate_hard_deletes config for better control over how to handle deleted rows from the source.

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