Snowflake Connector Guide

Snowflake Connector Guide

Troubleshooting

Troubleshooting

When you select the truncate table option for a Snowflake target that contains special characters and enable pushdown optimization, the mapping fails.
You must add the custom property AddQuotesAlways and set the value to Yes for the Data Integration Server in the Secure Agent properties.
The following image shows the custom configuration that must configure:
You can then run the Snowflake ODBC mapping with the truncate table option and with pushdown optimization enabled.
How do you configure pushdown optimization using an ODBC connection in a mapping task for an upsert or update operation to Snowflake?
In the advanced session properties on the Schedule tab, select Allow Temporary View for Pushdown as the session property name and select Yes as the session property value.
For more information, see the KB article: https://informatica.com/solution/23/Pages/71/579225.aspx

Updated September 05, 2019


Explore Informatica Network