How to Merge Data Using Change Data Capture in Databricks

[@sayanm7750]

Thanks for the nice explanation. Can you please also elaborate how (with associated syntax) to Delete from existing version records if the same did not come in the new version of data i.e. for 'not_matched_action' case?

[@shokyeeyong6469]

Is it possible with this demo and I change the target to a SQL DW table?

[@rahulpathak868]

just append data in target dw table