Load Change Data Capture data from PostgreSQL to Amazon Redshift

An upsert operation enables you to either insert a new record or update an existing record within the same transaction. To determine whether a record already exists or not, the set of queries rely on the incoming records’ primary key(s).

If you’d like to follow along, here are the PostgreSQL and Amazon Redshift table structures and schemas for the table I’ve used in this example:

Here’s what happening in the above set of SQL queries:

Related posts:

The BSFF methodology — that is, Be Set Free Fast, consists of five steps and helps a person to discover his problem, or rather the main reason for the obstacles in his path in the form of negative…

I have the odd habit of talking to cars. I found out, in these interviews, that some have self-image issues.