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

[Kaniz]

You can upsert data from a source table, view, or DataFrame into a target Delta table by using the MERGE SQL operation. Delta Lake supports inserts, updates, and deletes in MERGE, and it supports extended syntax beyond the SQL standards to facilitate advanced use cases.

You must have a look at this article.

[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