Forum Discussion

BW_RFA's avatar
BW_RFA
Icon for Helper I rankHelper I
2 years ago

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...
data engineering
Data Integration
data science
data warehouse
BW_RFA's avatar
BW_RFA
Icon for Helper I rankHelper I
2 years ago

I have realised that "EXCEPT" is not supported in Delta yet. How can I solve this problem? 

 

I want to only update the columns that have changed, not all of the columns.