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?