Can I merge delta lake table to RDBMS table directly? Which is the preferred way in Databricks?

[Krish-685291]

Hi,

I am dealing with updating master data. I'll do the UPCERT operations on the delta lake table. But after my UPCERT is complete I like to update the master data on the RDBMS table also. Is there any support from Databricks to perform this operation affectively in highly performant way. There are pyspark sql ways as shown below, but I don't see the merge option.

Appreciate any help on this.

Thanks

Krishna

[Krish-685291]

Hi,

My problem is that my target delta table is an RDBMS tables. MERGE SQL works on the tables which are in Databricks. Is it possible to mention in the MERGET SQL, that my target table is an RDBMS table? I didn't see that kind of syntax. Please let me know if I am missing something here.

Thanks

Krishna