In Informatica 10.4.0, we can use Snowflake data objects as dynamic sources and targets in a mapping.
Check if the below user guides helps here:
Yes, you need to use the 'Powerexchange for Snowflake' connector to be able to read/write to snowflake dynamically through the dynamic mapping feature in IDQ. However, the dynamic mapping support for the 'PowerExchange for Snowflake' connector was added in 10.4 and onwards. Please refer to the following article: https://network.informatica.com/community/informatica-network/products/data_integration/informatica_platform/blog/2019/12/02/informatica-104-is-now-available
Dynamic mapping feature is not available in version 10.2.0.