By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Zero-ETL: padb_internal_txn_seq_col, padb_internal_txn_id_col appended columns

0

Zero-ETL appends 2 additional columns to the redshift table (padb_internal_txn_seq_col, padb_internal_txn_id_col). Does anyone know how I can use those values to identify only the most recent inserts and updates so that I can update all the downstream transformations? There doesn't appear to be any documentation or examples of warehousing the data after Zero-ETL.

Topics
DatabaseAnalytics
Tags
Extract Transform & Load DataAmazon RedshiftAmazon Aurora zero-ETL integration with Amazon Redshift
Language
English
asked a year ago468 views
1 Answer
0

To identify recent inserts and updates, you could sort the table by padb_internal_txn_seq_col in descending order.

EXPERT
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content