When you run a mapping in advanced mode and if a column is renamed or a field is added to the source, the target schema is jumbled because of the difference in columns in the source and target schema.

To avoid this, set the following properties, separated by an ampersand, in the

Additional Write Runtime Parameters

field in the Target transformation:

column_mapping=name
column_mismatch_behavior=ignore

When you set these properties,

Data Integration

includes the name and also ignores any mismatch between the source and target schema when the column names contain uppercase letters, digits, or underscore.

If the column names do not contain uppercase letters, you must additionally set the

keep_column_case=on

parameter in both the Source and Target transformations:

For the source, set the parameter in the
Additional JDBC URL Parameters
of the Snowflake Data Cloud connection.
For the target, specify the parameter in the
Additional Write Runtime Parameters
property of the Target transformation.