Skip to main content

invalidate_hard_deletes

snapshots/<filename>.yml
snapshots:
- name: snapshot
relation: source('my_source', 'my_table')
config:
strategy: timestamp
invalidate_hard_deletes: true | false
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.yml
snapshots:
- name: orders_snapshot
relation: source('jaffle_shop', 'orders')
config:
schema: snapshots
database: analytics
unique_key: id
strategy: timestamp
updated_at: updated_at
invalidate_hard_deletes: true
0