Snowflake Connector Guide

Snowflake Connector Guide

Pushdown Optimization

Pushdown Optimization

You can use pushdown optimization to push transformation logic to source databases or target databases. Use pushdown optimization when you use database resources to improve the performance of the task.
When you run a task configured for pushdown optimization, the task converts the transformation logic to an SQL query. The task sends the query to the database, and the database executes the query.
Snowflake Connector supports Full and Source pushdown optimization for the ODBC connection type that uses Snowflake ODBC drivers for mapping.
You need to apply EBF CON-7357 to use Pushdown Optimization option. Contact Informatica Global Customer Support to install the Informatica EBF CON-7357.

Example

You are a sales manager in a rapidly growing manufacturing organization. Your organization stores the product transaction details such as transactionID, customerID, productID, quantity, product_revenue, and OrderDate in Snowflake database. You need to calculate the total revenue generated from the sales of a particular product. Use Snowflake Connector to create a mapping to read all the product revenue details of a particular product from the Snowflake source, apply aggregate function to calculate the total revenue, and write the records to Snowflake target for data analysis.
The organization plans to implement a business intelligence service to build visualization and perform real-time analysis. Therefore, you need to port the vast amount of data stored in Snowflake database to the business intelligence service. You can use Snowflake Connector to read data from Snowflake. To read this large amount of data, you can use full or source pushdown for the ODBC connection type. Using the ODBC connection type with pushdown optimization enhances the performance.


Updated November 07, 2019


Explore Informatica Network