manipulating dbt_valid_to timestamp in dbt snapshot

Hi everyone, a question on snapshots:
In my process I need to subtract a millisecond from the subsequent record’s “valid_from” timestamp and this value should be updated as “valid_to timestamp” of the current record ( rather than simply updating to the “valid_from” of the next row as is…)
How can I configure this manipulation within the snapshot mechanism?
Thanks in advance for all the help!

Two options:

Thank you so much for the response @joellabes !

1 Like

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