I’m fairly new using DBT and need to understand how can one load history into dbt snapshot.
We’re migrating from on prem to cloud so most of our historical data is stored on Prem.
We’re planning to use snapshot for daily on day 1 Go live, however not sure how can the On Prem History loaded to SnapShot table using insert into?
Is it possible at all ? Any help would be appreciated.