Implementing the upsert operation using Amazon Redshift V2 Connector

Implementing the upsert operation using Amazon Redshift V2 Connector

Overview

Overview

You can configure the insert, update, and delete operations using Amazon Redshift V2 Connector to add, update, and remove data rows in Amazon Redshift. However, if you want to perform an upsert operation in Amazon Redshift from Cloud Data Integration, you need to include additional configurations based on your requirement.
You also need to consider the following factors before you can upsert data to Amazon Redshift:
  • The data row is already available in the Amazon Redshift target table.
  • More than one data row for a key field or entity is available for a specific batch of commit to the Amazon Redshift data warehouse table.
The first scenario is already addressed using Amazon Redshift v2 Connector. Use the solutions described in the article to address the second scenario.