Is there any way we can update particular records in the RDS source?
We are planning to track deleted records in a separate table in source and once these rows are deleted from our Redshift table, we would like to update an indicator in the source table for the records which have been processed in our Matillion job.
2 Community Answers
Craig Rouse —
If you can create a table (or view!) in Redshift of the rows needing to be inserted/updated in the RDS table, you could possibly use the RDS Bulk Load component.
Hope that helps,