Forum Discussion

rsharma2's avatar
rsharma2
New Contributor II
8 years ago

Redshift -SCD2 snap

Has someone used Redshift SCD2 snap? I am looking for some sample pipeline to setup a SCD2 on one of my Redshift tables.
Requirement is to insert a new row and in case of an existing row ,expire the old row and insert a new row.

1 Reply

  • kichcha's avatar
    kichcha
    New Contributor II

    Did you get a chance to implement this? If so, could you please share the pipeline?