'Redshift CDC or delta load

Any one knows best way for loading delta or CDC with using any tools

I got big table with billions of records and want to update or insert like Merge in Sql server or Oracle but in Amazon Redshift S3

Also we have loads of columns as can't compare all columns as well

e.g

TableA Col1 Col2 Col3 ...

It has say already records SO when inserting new records need to check that particular record is already existing if so no insert if not insert and if changed update record like that I do have key id and date columns but as its got 200+ columns not easy to check all columns and taking much time

Many thanks in advance



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source