pragya17
New Contributor III

@Dolly0503 Watermark doesn't need a date column from silver/gold. You can use pipeline run timestamp as the watermark — tracking when the pipeline last ran, not when data was modified. Also you can use Delta table version history within watermark  as no date column will be needed .

Second , you can use Delta Change Data Feed - best for no date column and row level changes .