Forum Discussion

sg_dev's avatar
sg_dev
New Contributor
2 years ago

Update SQL Server table with complex update statement

We have a specific requirement where we need to import some data from several sources (example: Snowflake) and load them in SQL Server on premise table. Once that is done, some of the columns of the ...
manichandana_ch's avatar
manichandana_ch
New Contributor III
2 years ago

Hi sg_dev,

In the SQL Account being used in the SQL Server execute snap, please try edit account and under the Advanced properties, check the batch size(usually 50) and try increasing it to a higher number. That should reduce the time taken.

Thanks !