Thank you for the response. Indeed, this function works well for my case 🙂

However, I am currently using a Data Factory to extract the data into files and process them like the apply_change_snapshot function does.

Today, my pipeline is no longer working, and it's generating the following exception: terminated with exception: [DELTA_MERGE_MATERIALIZE_SOURCE_FAILED_REPEATEDLY] Keeping the source of the MERGE statement materialized has failed repeatedly. SQLSTATE: XXKST.

Any idea please 😞