To use PowerExchange for Snowflake on PowerCenter, you need the license SKU “PowerExchange for Cloud Applications”. This license allows one instance of a connector of Type D and one of Type B. Snowflake is a type D connector. For more information, see the Informatica Connectivity Product Availability Matrix (PAM) on Informatica Network.
PowerExchange for Snowflake is available on PowerCenter 10.2 as a separate installer. In 10.2 HotFix 1, PowerExchange for Snowflake is included with the installer and is enabled with the license.
Snowflake Connector requires the “SDKPatch” package. Verify if you have the licence on the Licence page on Informatica Intelligent Cloud Services. If you do not have the license, contact Global Customer Support.
Informatica uses an interface provided by Snowflake that internally uses the Snowflake JDBC driver.
Snowflake Connector uses the following version of the Snowflake JDBC driver version:
Yes, Informatica Intelligent Cloud Services and PowerCenter 10.2 Hotfix 1 supports Snowflake on Azure.
On Informatica Intelligent Cloud Services and PowerCenter, you can configure pushdown optimization for the Snowflake database using the ODBC connection. The connector supports both Partial and Full pushdown optimization. You can configure pushdown optimization for within a schema or across multiple schemas in Snowflake. For more information about the rules and guidelines for configuring pushdown optimization, see the respective Snowflake connector documentation.
On Data Quality, only Filter pushdown optimization is supported. Full pushdown optimization is not supported when you use the Snowflake connection or the ODBC connection.
When you use PowerExchange for Snowflake from Big Data Management. you can configure pushdown optimization for a mapping to run on the Spark engine.
Yes, Snowflake Connector supports the Hosted Agent. You need the Hosted Agent license to use the agent with Snowflake Connector.
Yes, you can configure key range partitioning while reading data from Snowflake. You can configure pass-through partitioning along with other target properties to partition data while writing data to Snowflake. For more information, see the respective Snowflake connector guide.
Yes, you can use proxy with PowerCenter for Snowflake in PowerCenter 10.2 HotFix 1. You can also use proxy for the Snowflake connection in the current Informatica Intelligent Cloud Services release.
Yes, you can use bulk options for the following properties:
For more information, see the respective Snowflake connector guide.
When you use Snowflake Connector on Informatica Intelligent Cloud Services, you can use “Query” as a source object type.
When you use PowerExchange for Snowflake on PowerCenter, you can configure " SQL Query" after adding a patch "EBF-11911" with 10.2 HotFix 1. Contact Global Customer Support for the patch, which is available only with 10.2 HotFix 1 release.
When you use Snowflake Connector on Informatica Intelligent Cloud Services, you can configure an SQL override by using the property “SQL Override” in the “Advanced Properties”.
When you use PowerExchange for Snowflake on PowerCenter, you can use a Pipeline Lookup for Snowflake, which uses an SQL Query as a source. Contact Global Customer Support to get the patch “EBF-11911” to apply on PowerCenter 10.2 HotFix 1.
Yes, you can read data from Snowflake tables and views.
For information about the various data types that Snowflake Connector supports, see the topic “Snowflake and Transformation Data Types” in the respective on-premise or cloud Snowflake connector guide.
Yes, you can update existing data warehouse mappings to use Snowflake sources and targets. For more information, see the following KB article: https://kb.informatica.com/faq/7/Pages/21/547962.aspx
What can we do to improve this information (2000 or fewer characters)