Copy data into lakehouse and warehouse - append or overwrite

When creating a data pipeline that copies data into a lakehouse, I can choose whether to Append or Overwrite data. If I choose to Overwrite, repeated runs of the pipeline do not create duplicate records.

 

However, there is no option to Append or Overwrite when creating a data pipeline that copies data into a warehouse. As a result, repeated runs of the pipeline create duplicate records in the warehouse.

 

 

Shouldn't the option to Append or Overwrite be present in the warehouse experience too?

 

Or have I misunderstood the intent? Any wisdom appreciated.

 

Thank you

 

Duncan