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