Snowflake Cloud Data Warehouse V2 Connector > Upgrading to Snowflake Cloud Data Warehouse V2 Connector > Properties retained after the switch
  

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 Cloud Data Warehouse V2 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 Cloud Data Warehouse V2 mappings:
Properties
Snowflake ODBC properties retained in Snowflake Cloud Data Warehouse V2
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 Cloud Data Warehouse V2 mappings:
Properties
Snowflake V1 properties retained in Snowflake Cloud Data Warehouse V2
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