Merge operations are not supported in streaming jobs without the use of Watermarking.

Merge operations cannot delete records; they only support upsert operations.

Merge operations cannot proceed if a single source row matches and attempts to modify multiple target rows in the table.

Merge operations cannot proceed if multiple source rows match and attempt to modify the same target row in the table.

All the above are considered limitations of the MERGE INTO command.