The following table lists the configured advanced source, lookup, and target properties from Snowflake V1 mappings that you can retain when you migrate to Snowflake Data Cloud:
Transformations
Snowflake V1 properties retained after migration to 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
Consider the following rules before you migrate the Snowflake V1 connection referenced in an existing mapping to the Snowflake Data Cloud connection:
If the existing mapping contains multiple objects, the relationship between these objects is not preserved after you switch to the new connection.