Snowflake Metadata Caching

Configure Snowflake metadata caching in your Snaplex by setting global JVM properties to control cache status, size, and expiration for Snowflake pipelines.

You can configure global cache properties for Snowflake metadata in your Snaplex. To set these values:

  1. Navigate to SnapLogic Manager > Asset Search > Snaplexes and click the Snaplex on which you want to execute the Pipeline containing the Snowflake Snap. The Update Snaplex popup window appears.
  2. Click Node Properties and, at the bottom of the tab that appears, set the Global properties. You can configure cache properties in your Snaplex for Snowflake pipelines using the following JVM properties:
    Cache property JVM option
    Cache status: Set this value to true to enable caching.

    snaplogic.db.metadata.cache.enabled

    Default value: false

    Example: snaplogic.db.metadata.cache.enabled=true
    Cache size: Maximum entries in cache mode. Entry refers to complete schema information.

    snaplogic.db.metadata.cache.size

    Default value: 1000

    Example: snaplogic.db.metadata.cache.size=1500
    Cache expiration duration: Expiration duration (minutes).

    snaplogic.db.metadata.cache.duration.minutes

    Default value: 120

    Example: snaplogic.db.metadata.cache.duration.minutes=250

    snowflake metadata caching