Help Understanding Snapshots invalidate_hard_deletes

I’m trying to understand the full impact of configuring invalidate_hard_deletes for snapshots.

My understanding is this causes dbt to populate dbt_valid_to when a source record is recognized as deleted. Is this the only behavior of this configuration flag?


Yes that’s right - if a record is deleted, its dbt_valid_to will be set to the time the dbt snapshot runs instead of staying “open” by being null.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.