Understanding Effective_dates with starts and ends

For the effective from columns (src_eff) of a satellite, how does it handle the previous record with the ‘old’ name? Documentation said that it isn’t valid, but what if we need to go back and query the old records? How do we select those rows. One of my data architects are used to seeing an effective_from start and end date columns within the regular DV methodology How does dbt bring that over or does it remove it and the effective end date is the new record’s start date within the dbt code?

“Regular DV methodology” to which you refer is DV1 or maybe even Ensemble Data Vault — DV2.0 the end-date is virtualised using window functions

this should help: https://www.snowflake.com/blog/data-vault-technique-immutable-storage/

1 Like