Specify the Java heap space memory as -Xmx256m in the Secure Agent properties to avoid the JDBC driver internal errors in mappings and mapping tasks that read data from Snowflake:
This update does not apply for mappings configured with SQL ELT optimization using the Snowflake ODBC connection.
Perform the following steps to configure the JVM memory:
1In Administrator, select the Secure Agent listed on the Runtime Environments tab.
2Click Edit.
3In the System Configuration Details section, select Data Integration Service as the service and DTM as the type.
4Edit the JVMOption1 property, and enter -Xmx256m.