Snowflake Cloud Data Warehouse V2 Connector > Snowflake pushdown optimization > Pushdown optimization scenarios
  

Pushdown optimization scenarios

You can configure pushdown optimization using the Snowflake Cloud Data Warehouse V2 Connector or the Snowflake ODBC Connector in mappings.

Snowflake Cloud Data Warehouse V2 Connector

Important: To configure pushdown optimization using the Snowflake Cloud Data Warehouse V2 Connector, verify that your organization has the advanced pushdown optimization license. To get the license, contact Global Customer Support.
You can use configure pushdown optimization for the following scenarios when you use Snowflake Cloud Data Warehouse V2 Connector in mappings:
Source and target endpoints
Supported pushdown scenarios in mappings
Pushdown optimization type
Snowflake source
Snowflake target
Reads from and writes to Snowflake tables using the Snowflake Cloud Data Warehouse V2 connection. You can also read from Snowflake external tables, views, and materialized views.
Source, Full
Note: The Secure Agent pushes the entire mapping logic or only the partial mapping logic, as applicable, for processing to Snowflake.
Amazon S3 source
Snowflake target
Reads from Amazon S3 using an Amazon S3 V2 connection and writes to Snowflake using a Snowflake Cloud Data Warehouse V2 connection.
Full
Google Cloud Storage source
Snowflake target
Reads from Google Cloud Storage using a Google Cloud Storage V2 connection and writes to Snowflake using a Snowflake Cloud Data Warehouse V2 connection.
Full
Microsoft Azure Data Lake Storage Gen2 source
Snowflake target
Reads from Microsoft Azure Data Lake Storage Gen2 using a Microsoft Azure Data Lake Storage Gen2 V2 connection and writes to Snowflake using a Snowflake Cloud Data Warehouse V2 connection.
Full
You can use the Secure Agent, Hosted Agent, or the Serverless runtime environment to run mappings enabled with pushdown optimization.

ODBC Connector

Important: Informatica recommends that you use the Snowflake Cloud Data Warehouse V2 connection in mappings to configure pushdown optimization. If you cannot push down specific transformation logic using the Snowflake Cloud Data Warehouse V2 connection, you can explore configuring pushdown optimization using the Snowflake ODBC connection.
You can configure pushdown for a mapping that uses a Snowflake ODBC connection to read from and write to Snowflake.
Source and target endpoints
Supported pushdown scenarios in mappings
Pushdown optimization type
Snowflake source
Snowflake target
Reads from and writes to Snowflake using the Snowflake ODBC connection with the Snowflake ODBC subtype.
The Snowflake ODBC connection uses the Snowflake ODBC 64-bit drivers on Windows and Linux systems. You must configure the Snowflake driver based on your system requirement.
Full, Source
You can use the Secure Agent to run mappings enabled with pushdown optimization.
Note: You cannot configure pushdown optimization for a mapping task that is based on an elastic mapping.