[Deprecation Marker Required] : MERGE INTO Clause

Gajju — Fri, 17 Jan 2025 09:49:43 GMT

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?

Re: [Deprecation Marker Required] : MERGE INTO Clause

User16502773013 — Fri, 17 Jan 2025 16:22:54 GMT

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

topic Re: [Deprecation Marker Required] : MERGE INTO Clause in Data Engineering

[Deprecation Marker Required] : MERGE INTO Clause

Re: [Deprecation Marker Required] : MERGE INTO Clause