Hello,

To begin, enable delta properties for your gold table if it isn’t already a delta table. Next, activate the Change Data Capture (CDC) delta property. This will give you a detailed log of insert, update, and delete operations at the row level, which you can use to perform DML operations on your Postgres tables with minimal coding effort.

Hello @hari-prasad, 
Thanks you for your answer, considers that we are using DLT Pipelines, is it a good choice in this case? Because actually I don't see with DLT Pipelines the metadata for these materialized tables in this case these CDF statements