There is extensive SCD2 support built into the ELT snaps which support Azure Synapse. If you use the ELT snaps you will want to load the raw data into a staging table that is used as the source for the SCD2 input. The ELT snaps do not move data instead they execute SQL within the CDW, Synapse in this case, allowing them to be extremely efficient. Performance often needs to be considered when implementing a SCD2 solutions which in some cases requires confirming unique primary keys for current rows within a large table.
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1839792882/ELT+SCD2
