Forum Discussion
Update delta table only with changed fields
Hi, I have a delta table that needs updating with new data every 10 mins. The data that comes in has many fields but maybe only 1 of them is actually different from the target table. As I nee...
I have attached code at the bottom of the topic to reproduce the issue.
df1 is to be used to build the initial table to replicate the table that i have, and df2 is to replicate the update file that would come in.
The sample output should be an updated table that has only updated row 1 label and NOTHING else. Not updating the whole of row 1 with the data that's in df2 row 1 as the "static" field hasn't changed.