Fabric Copy Activity Upsert Needs Native Audit Columns

Hi Yazdan , 

Thank you for reaching out to the Microsoft Community Forum.

Thanks for sharing this feedback.
Agree that native audit column handling for Copy Activity Upsert would be very useful, especially for Delta Lakehouse operational loads without using Spark notebooks.

The current Copy Activity Upsert feature is already very powerful for fast ingestion scenarios, and adding built-in support for columns like DW_DATE_INSERT and DW_DATE_UPDATE would make it even better.

Useful Microsoft Learn references:

How to copy data using copy activity - Microsoft Fabric | Microsoft Learn

Configure Lakehouse in a copy activity - Microsoft Fabric | Microsoft Learn

Best Regards, 
Community Support Team