Forum Discussion

BW_RFA's avatar
BW_RFA
Helper 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
Helper 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello BW_RFA ,

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
    In case if you have any resolution please do share that same with the community as it can be helpful to others .
    Otherwise, will respond back with the more details and we will try to help .

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi BW_RFA ,

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
      In case if you have any resolution please do share that same with the community as it can be helpful to others .
      Otherwise, will respond back with the more details and we will try to help .