Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with Snowflake Data Cloud Connector
  3. Part 2: Data Integration with Snowflake Data Cloud Connector
  4. Part 3: SQL ELT with Snowflake Data Cloud Connector
  5. Appendix A: Data type reference
  6. Appendix B: Additional runtime configurations
  7. Appendix C: Upgrading to Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Configure JVM memory requirements

Configure JVM memory requirements

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:
  1. In Administrator, select the Secure Agent listed on the
    Runtime Environments
    tab.
  2. Click
    Edit
    .
  3. In the
    System Configuration Details
    section, select
    Data Integration Service
    as the service and
    DTM
    as the type.
  4. Edit the
    JVMOption1
    property, and enter
    -Xmx256m
    .
  5. Click
    Save
    .

0 COMMENTS

We’d like to hear from you!