Snowflake Connector Guide

Snowflake Connector Guide

Configuring Cross-Schema Optimization for a Snowflake Mapping Task

Configuring Cross-Schema Optimization for a Snowflake Mapping Task

Create two Snowflake mappings. For example, perform the following steps to configure cross-schema pushdown optimization for a Snowflake mapping task:
  1. Create the following two Snowflake ODBC connections, each defined with a different schema:
    1. Create an sf_odbc1 Snowflake ODBC connection and specify CQA_SCHEMA1 schema in the connection properties.
    2. Create sf_odbc2 Snowflake ODBC connection and specify CQA_SCHEMA2 schema in the connection properties.
  2. Create a Snowflake mapping, m_sf_pdo_acrossSchema. Perform the following tasks:
    1. Add a Source transformation and include a Snowflake source object and connection sf_odbc1 to read data using CQA_SCHEMA1.
    2. Add a Target transformation and include a Snowflake target object and connection sf_odbc2 to write data using CQA_SCHEMA2.
  3. Create a Snowflake mapping task, and perform the following tasks:
    1. Select the configured Snowflake mapping, m_sf_pdo_acrossSchema.
    2. In the Advanced Options on the Schedule tab, add Pushdown Optimization and set the value to Full.
    3. Select Enable cross-schema pushdown optimization.
      The following image shows the configured Enable cross-schema pushdown optimization property:
    4. Save the task and click Finish.
    When you run the mapping task, the Secure Agent reads data from the Snowflake source object associated with the CQA_SCHEMA1 schema and writes data to the Snowflake target object associated with CQA_SCHEMA2 schema.


Updated November 07, 2019


Explore Informatica Network