invalidate_hard_deletes legacy

Legacy opt-in configuration to enable invalidating hard deleted records while snapshotting the query.

This is a legacy config — Use the hard_deletes config instead.

In dbt Cloud release tracks 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.

For new snapshots, set the config to hard_deletes='invalidate' instead of invalidate_hard_deletes=true. For existing snapshots, arrange an update of pre-existing tables before enabling this setting.

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