SCD2 implemmetation in snaplogic using azure snappacks

I have a database table in azure sql and I am getting daily data from a dataset,then I have to compare dataset record with database table records and
1 : Insert the records that are present in dataset but not in database into database in sql
2 Apply scd2 on updated records.
How can i do it using azure snap packs in snaplogic as my database is azure db.
please anyone help its urgent.