Can I merge delta lake table to RDBMS table directly? Which is the preferred way in Databricks?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2022 07:56 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2022 04:22 AM
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
