Snowflake Cloud Data Warehouse V2 Connector > Upgrading to Snowflake Cloud Data Warehouse V2 Connector > Connection switching example
  

Connection switching example

You want to upgrade your existing Snowflake mapping that uses the Snowflake V1 connection to the Snowflake Cloud Data Warehouse V2 connection.
    1. Open the existing Snowflake V1 mapping that you want to upgrade to Snowflake Cloud Data Warehouse V2.
    The following image shows an existing mapping that uses the Snowflake V1 connection and contains the configured advanced properties in the Target transformation:
    The connection type used is Snowflake V1 connection.
    The configured target object path in this example is: CQA/CQA_SCHEMA/AM_CUSTOMER_SRC
    2. To 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 Snowflake V1 mapping:
    3. To switch the connection, in the Connection field, change the connection from Snowflake V1 to Snowflake Cloud Data Warehouse V2.
    4. In the Change Connection dialog box, select the following properties, and click Yes:
    The following image shows the options that you must select:
    The dialog box shows the options to retain the advanced properties and the field mapping.
    5. Use the same object path in the mapping as Snowflake V1.
    The following image shows the switched connection with the same object path: CQA/CQA_SCHEMA/AM_CUSTOMER_SRC
    The connection is switched to Snowflake Cloud Data Warehouse V2 type.
    The configured target advanced properties from the Snowflake V1 mapping reflect in the Target transformation.
    6. If you had selected Manual on the Field Mapping tab in the Snowflake V1 mapping and you want to reflect the field mappings in Snowflake Cloud Data Warehouse V2, on the Field Mapping tab, select Automap, and then select Previous Mapping.
    The automap option is selected to retain the mappings from the old connector.
    Note: If you had selected Automatic in Snowflake V1, you do not have to perform this task.
    In the following image, the configured mapped fields from the Snowflake V1 mapping reflects in the Snowflake Cloud Data Warehouse V2 mapping:
    The Field Mapping tab shows the mapped fields reflecting in the Snowflake Cloud Data Warehouse V2 mapping.
    7. Click Save.