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..

Yes... insert + delete + update is the same as merge. Do you have a specific question? — Nick.McDermaid, Jan 19 '18 at 13:56
yes...i want to know all methods to load incremental data into redshift with sql and i want to know how to avoid duplicates? — mounika nerella, Jan 20 '18 at 17:45
This site isn't about people doing your research for you. This site is about you trying something and returning with a specific question. — Nick.McDermaid, Jan 21 '18 at 01:11

score 2 · Answer 1 · answered Jan 19 '18 at 13:50

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.

1 Answers1