Snowflake Cloud Data Warehouse V2 Connector > Custom configurations > Bulk processing for write operations
  

Bulk processing for write operations

You can enable bulk processing to write large amounts of data to Snowflake. Bulk processing utilizes minimal number of API calls and the performance of the write operation is optimized.
To enable bulk processing, specify the property -DENABLE_WRITER_BULK_PROCESSING=true in the Secure Agent properties:
Perform the following steps to configure bulk processing before you run a mapping:
  1. 1. In Administrator, select the Secure Agent listed on the Runtime Environments tab.
  2. 2. Click Edit.
  3. 3. In the System Configuration Details section, select Data Integration Server as the service and DTM as the type.
  4. 4. Edit the JVM option, and enter -DENABLE_WRITER_BULK_PROCESSING=true.
  5. 5. Click Save.
Note: This update does not apply for mapping tasks configured with pushdown optimization using the Snowflake ODBC connection or the Snowflake Cloud Data Warehouse V2 connection.