How to load CDC into Redshift database?

Question

Can anyone tell me CDC /incremental load methods in Redshift using SQL?

I know one method upsert but other than this there are another methods to do like insert followed by delete etc..

Answer 1

Redshift doesn't support UPSERT or MERGE in SQL but we have a few data merge examples in the docs: https://docs.aws.amazon.com/redshift/latest/dg/merge-examples.html

Remember that you can use these patterns inside a transaction so you can rollback if something fails.