It is currently not possible to modify the actual names of the snapshot metafields (
dbt_valid_from
and friends) even if you go down this path to customize the built in macros below - dbt-labs/dbt-core#7018
Customising dbt snapshots so that dbt_valid_from
dates can use a variable.
Macros that need to be overridden are in the materializations/snapshots
folder in dbt-core
.
- Setup initial snapshot: