Hi All,

I have 20 tables in source sql DB and we need to create pipeline to incrementally load data into target database .

Can some one please suggest me best approach to achieve this using Azure Databricks please?

Should i use merge Into ? Copy Into? or something else please?

Please note all tables have a column which i can use to identify any changes happening in source .