Snowflake Data Cloud Connector

Back Next

Properties retained after the switch

When you replace the source or target connection type in existing mappings or mapping tasks that use the Snowflake V1 connection or the Snowflake ODBC connection with the Snowflake Data Cloud connection, you have the option to retain the configured advanced properties and the field mappings.

The following table lists the configured advanced source, lookup, and target properties from the Snowflake ODBC connection that are retained in Snowflake Data Cloud mappings:

Properties	Snowflake ODBC properties retained in Snowflake Data Cloud
Source	Pre SQL Post SQL
Target	Pre SQL Post SQL Truncate target Forward rejected rows Update override

The following table lists the configured advanced source, lookup, and target properties from Snowflake V1 retained in Snowflake Data Cloud mappings:

Properties	Snowflake V1 properties retained in Snowflake Data Cloud
Source	Database Schema warehouse Role Pre SQL Post SQL Table name SQL override Tracing level
Lookup	Database Schema Warehouse Role
Target	Database Schema Warehouse Role Pre SQL Post SQL Batch row size Number of local staging files Truncate target table Additional runtime properties Table name Rejected file path Success file directory Error file directory Forward rejected rows