I’m ingesting a file using DLT and I would like to create 2 new columns:
CreateDate and UpdateDate for all the records. UpdateDate is easy as I can just use the current date (although it would be nicer if this column didn’t update again if no other columns actually changed). But what I’m having difficulty doing is I don’t want CreateDate to ever be updated, as that should just contain the information when the data was first ingested and so should never change.