Hi @amarnathpal, 

Do you want to add a new column after or while reading data from the source?

If you want to add after reading, you can just add a withcolumn statement after reading the data, but the data which has been processed already will have null values and the new incremental data will have the timestamp or date. 

Hi @nikhilj0421 

yeah but that will give the current timestamp, but here i want based on the records got updated then i want to update the column with that day date.

Hi @amarnathpal , could you pls elaborate your case?

But generally, if it's same as I think, you could use MERGE INTO or Delta Live Table to update the "updated" column.

Do you want to add dates for the historical data as well?