[Deprecation Marker Required] : MERGE INTO Clause

[Gajju]

Dear Friends:

Considering MERGE INTO may generate wrong results(The APPLY CHANGES APIs: Simplify change data capture with Delta Live Tables | Databricks on AWS), may I ask that why it's API is still floating in technical documentation, without "Deprecated/Obsolete Marker" ?

It's causing confusion.

Is there any use case where MERGE wins over APPLY CHANGES INTO?

[User16502773013]

Hello @Gajju ,

MERGE INTO is not being deprecated, APPLY CHANGES should be seen as an enhanced merge process in Delta Live Table that handles out of sequence records automatically as shown in  the example in the documentation shared.

The notion of wrong results is pertaining to handling out of sequence records which may be prone to errors due to logic implementation in MERGE INTO

MERGE wins when you you need full control of out of sequence without built-in sequencing feature use cases

Regards