What is is the optimize way, configuration of inserting 100k records using delta connector?

[mustafa-rmd]

Greeting,

I want to be able to inset 100k records at once shot to delta lake table. What is the most optimal way to achieve this?

I am connecting to trino server using JDBC connection.
I try add batch insert. However, it seem like it is not supported yet by trino.

Even when I try insert 5k record then after 3 sec I try to insert another 5k the server crash and it has to re-initialized (Memory issue).

My setup is one coordinator and one worker.

Thanks, in advance.