You would have to purchase the IDQ connector for Snowflake to start or use a generic odbc/jdbc connection.

Thanks,

Scott

Hello Kannan ,

You can have a look at below guide :

Yes, you can read and write dynamically to a Snowflake data object in 10.4. Please refer to the below product docmunetation on supported source and targets for dynamic mapping:

Dynamic Sources

You need to raise a shipping case with Informatica to obtain the license for snowflake connector or you can use JDBC/ODBC connection with suitable drivers to connect to snowflake.

Hi Kannan,

You can refer the below documents.

https://knowledge.informatica.com/s/article/564478?language=en_US

https://docs.informatica.com/data-integration/powerexchange-adapters-for-informatica/10-4-1/powerexchange-for-snowflake-user-guide/introduction-to-powerexchange-for-snowflake.html

Hope that helps.

Thanks.

Hi Kannan,

Please note you need to use the "PowerExchange for snowflake" connector to be able to use Snowflake in IDQ dynamic mappings. Also, dynamic mapping support for Snowflake was added in 10.4.0. You cannot use snowflake in dynamic mappings before 10.4.0.

Documentation: PowerExchange for Snowflake Dynamic Mappings

Let me know if this helps.

Regards,

Krishna

Hi Kannan,

The dynamic mapping support for the PowerExchange for Snowflake connector was added in 10.4 and onwards. Please refer to the following article: Informatica 10.4 is Now Available

This feature is not available in 10.2 HF2.

Regards,

Krishna