Implementing the upsert operation using Amazon Redshift V2 Connector

Back Next

Use case

You want to perform an upsert operation when there are multiple data rows for a key field or entity.

Consider a dataset that has the following entities:

customer

and

credithistory

The

customer

dataset is a flat file with the following fields: customer ID and customer name. The customer ID uniquely identifies a customer.

The following image shows a list of customer IDs and customers:

The

credithistory

dataset denotes the credit score for a customer at intervals of three months.

The following image shows the credit history for the customers:

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.