is there a way to perform a bulk insert operation to insert data into MS SQL? currently we have a pipeline that has about 3.5M records / documents. It takes a long time to insert all of these into SQL using the execute snap b/c I believe its performing an insert document by document. Any help is appreciated.
Take a look at the SQL Server Bulk Load Snap
If you are using Azure SQL, there are additional options.