DBT Snapshot loading history

Hi,
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.

Thanks,
Nayan.

I think the best approach would be to load your historical data to your cloud db then call it as a source (Sources | dbt Docs). Then create your snapshot and use some fancy sql to merge the two together in your downstream models.

1 Like