How to implement SCD Type 2 without using snapshot

Hi,
We are migrating data from sql server into Snowflake using dbt. We already have a table which capture history data using stored procedure in sql server.
How do I implement scd type 2 in dbt without losing existing data?

Thanks in advance.