Try to see if increasing your cluster capacity helps (or adjusting cluster configuration). This worked for me when I encountered the same error after trying to merge a large dataframe to an existing large delta table (i.e. [DELTA_MERGE_MATERIALIZE_SOURCE_FAILED_REPEATEDLY] Keeping the source of the MERGE statement materialized has failed repeatedly.).