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