1Open the existing Amazon Redshift V1 mapping that you want to upgrade to Amazon Redshift V2.
The following image shows an existing mapping that uses the Amazon Redshift V1 connection and contains the configured advanced properties in the Source transformation:
2To retain the mapped fields from the field mapping when you switch the connection, on the Field Mapping tab, choose from the following Field Map Options menu in the Amazon Redshift V1 mapping:
- - To retain the fields automatically mapped after the switch, select Automatic.
- - To manually map the retained fields after the switch, select Manual.
Note: When you select manual, after switching the connection, you have the option to automap the retained fields using the previous mapping.
3To switch the connection, in the Connection field, change the connection from Amazon Redshift V1 to Amazon Redshift V2.
4In the Change Connection dialog box, select Connection Switch property, and click Yes:
- - Connection switch. Switches to the connection that you select.
- - Retain field mapping. Retains the configured field mappings from Amazon Redshift V1.
The following image shows the option that you must select:
5Use the same object path in the mapping as Amazon Redshift V1.
The following image shows the switched connection with the same object path as Amazon Redshift V1:
The configured source advanced properties from the Amazon Redshift V1 mapping reflect in the Source transformation.
6If you had selected Manual on the Field Mapping tab in the Amazon Redshift V1 mapping and you want to reflect the field mappings in Amazon Redshift V2, on the Field Mapping tab, select Automap, and then select Previous Mapping.
Note: If you had selected Automatic in Amazon Redshift V1, you do not have to perform this task.
7Click Save.