Skip to main content

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 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​

Was this page helpful?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

0
Edit this page