Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

Snowflake Cloud Data Warehouse Connector Related Queries
Answer

What version is the latest Snowflake Connector available with?

  • Informatica Intelligent Cloud Services Cloud Data Integration– Current
  • PowerCenter – 10.2  HotFix 1 with EBF-11911
  • Data Quality – 10.2 HotFix 1
  • Informatica Big Data Management – 10.2.1 (Next upcoming release is 10.2.2)


What license do I need to use PowerExchange for Snowflake on PowerCenter?

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


 

How do I install PowerExchange for Snowflake on PowerCenter?

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.


 

Does the Snowflake Connector need any additional packages for Cloud Data Integration on Informatica Intelligent Cloud Services?

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. 


 

How does Informatica access Snowflake?

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:  

  • PowerCenter - 3.0.20 (upgraded to 3.6.4 with 10.2.0 HotFix 1)
  • Data Quality – 3.0.20 (upgraded to 3.6.4 with 10.2.0 HotFix 1).
  • Informatica Intelligent Cloud Services - 3.6.4


 

Does Informatica support Snowflake on Azure?

Yes, Informatica Intelligent Cloud Services and PowerCenter 10.2 Hotfix 1 supports Snowflake on Azure.


 

Can I configure database pushdown optimization?

On Informatica Intelligent Cloud Services and PowerCenter, you can configure pushdown optimization for the Snowflake database using the ODBC connectionThe 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.


 

Can I configure pushdown optimization on the Spark engine?

When you use PowerExchange for Snowflake from Big Data Management. you can configure pushdown optimization for a mapping to run on the Spark engine.


 

Does Snowflake Connector on Informatica Intelligent Cloud Services support the Hosted Agent?

Yes, Snowflake Connector supports the Hosted Agent. You need the Hosted Agent license to use the agent with Snowflake Connector.


 

Can I configure partitioning?

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.


 

Can I configure a Snowflake connection using proxy?

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.


 

Can I configure bulk options to load data?

Yes, you can use bulk options for the following properties:

  • Batch row size
  • Number of local stage files
  • csvFileSize (JDBC parameter) 

For more information, see the respective Snowflake connector guide.


 

Can I use an SQL Query to read data from Snowflake?

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


 

Can I use an SQL Override for Snowflake lookups?

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.


 

Can I read data from tables and views in Snowflake?

Yes, you can read data from Snowflake tables and views.


 

What data types are supported?

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


 

Can I change existing data warehouse sources and targets in PowerCenter mappings in 10.2 HotFix 1 with Snowflake sources and targets?

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 

 


More Information

Applies To
Product: PowerExchange; PowerCenter; Data Quality; Big Data Management; Cloud Data Integration
Problem Type:
User Type:
Project Phase:
Product Version:
Database:
Operating System:
Other Software:

Reference

Attachments

Last Modified Date:10/2/2018 10:12 PMID:553165
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)