Snapshot historical data


I’m new at dbt and having some troubles with snapshots tables.
I have 2 tables: orders and orders_historys. Orders have the current orders state and orders history has all the chages to orders status. I can do a snapshot on orders but I would like to have all the historical data as well.

What are my options to achieve this?


I just found this Finding active days for a subscription/user/account (date spining)

which is pretty close to what I want to achieve :slight_smile:

1 Like