Effective in version 10.2 HotFix 1, PowerExchange for Snowflake includes the following new features:
You can configure a custom SQL query to configure a Snowflake source.
You can override the database and schema name when you create temporary tables in the Snowflake staging database. You must add the database and schema name that you want to override in the JDBC URL parameters of the Snowflake connection.
You can override the imported Snowflake source table name by specifying the table name in the Snowflake session properties. You can also configure a SQL override to override the default SQL query used to extract data from the Snowflake source.
You can override the Snowflake target table name by specifying the table name in the Snowflake target session properties.
You can configure source-side or full pushdown optimization to push the transformation logic to Snowflake when you use the ODBC connection type. For information about the operators and functions that the PowerCenter Integration Service can push to Snowflake, see the Informatica PowerCenter 10.2 HotFix 1 Advanced Workflow Guide.
You can join multiple Snowflake source tables by specifying a join condition.
You can configure an unconnected lookup transformation for the source qualifier in a mapping.
You can configure pass-through partitioning for a Snowflake session. After you add the number of partitions, you can specify an SQL override or a filter override condition for each of the partitions.
You can configure the HTTP proxy server authentication settings at design time or at run time to read data from or write data to Snowflake.
You can configure Okta SSO authentication by specifying the authentication details in the JDBC URL parameters of the Snowflake connection.
You can read data from and write data to Snowflake that is enabled for staging data in Azure or Amazon.
For more information, see the
Informatica PowerExchange for Snowflake 10.2 HotFix 1 User Guide for PowerCenter.