I have a CDC configured with Oracle RDS as source and Snowflakes as destination, Please share the better approach to perform Data Masking of few sensitive data columns and also few other custom data manipulation on the fly when the synch/replication is in progress.
Thanks in Advance!!!!
3 Community Answers
Ian Funnell —
We don’t currently have a supported way to perform data manipulation during the CDC replication process; currently you can only perform transformations after the data has been replicated.
If there are date/timestamp fields available on the source tables which allow you to identify updated/new rows, an option may be extracting sensitive tables from the source by using the RDS query component and using a select statement (e.g. selecting only the fields you need and passing in the date/timestamp as a variable).