Configuring Cross-Schema Optimization for a Snowflake Mapping Task
Configuring Cross-Schema Optimization for a Snowflake
Create two Snowflake mappings. For example, perform the following steps to configure cross-schema pushdown optimization for a Snowflake
Create the following two Snowflake ODBC connections, each defined with a different schema:
sf_odbc1 Snowflake ODBC connection and specify
CQA_SCHEMA1 schema in the connection properties.
sf_odbc2 Snowflake ODBC connection and specify
CQA_SCHEMA2 schema in the connection properties.
Create a Snowflake mapping,
m_sf_pdo_acrossSchema. Perform the following tasks:
Add a Source transformation and include a Snowflake source object and connection
sf_odbc1 to read data using
Add a Target transformation and include a Snowflake target object and connection
sf_odbc2 to write data using
Create a Snowflake
mapping task, and perform the following tasks:
Select the configured Snowflake mapping,
Advanced Options on the
Schedule tab, add Pushdown Optimization and set the value to Full.
Enable cross-schema pushdown optimization.
The following image shows the configured
Enable cross-schema pushdown optimization property:
Save the task and click
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