Will MERGE incur a lot driver memory

MikeGo
Valued Contributor

Hi team,

We have a job to run MERGE on a target table with around 220 million rows. We found it needs a lot driver memory (just for MERGE itself). From the job metrics we can see the MERGE needs at least 46GB memory. Is there some special thing to make MERGE using a lot driver memory?

Thanks