Consider the following rules before you replace the Amazon Redshift ODBC connection or Amazon Redshift V1 connection in an existing mapping with the Amazon Redshift V2 connection:
When you specify the pre-SQL, post-SQL, and SQL query commands in the source and target properties for Amazon Redshift and upgrade the connection to Amazon Redshift V2, the queries are truncated. The issue occurs when the number of characters in the queries in the Amazon Redshift ODBC connection or Amazon Redshift V1 connection exceeds 65535.
Even after you replace the connection with the Amazon Redshift V2 connection, the object field displays the object that you selected in the earlier connection. You need to reimport the Amazon Redshift object and remap the fields in the mapping.