Forum Discussion
pmscorca
Post Prodigy
Post ProdigyAdding a custom column to a copy activity
Hi, is it possible to add a custom column to a copy activity? I'd like to add a load date for each tables copied from a source to a destination, using the for each activity. Any helps to me, pleas...
Hi,
I've solved specified this column and the related expression:
@formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ss')
In the lakehouse the actual datetime column is created as a string/char type and not a date type.
NandanHegde
Super User
Super UserSimilar to ADF, in data pipeline copy activity as well you can add additional column
pmscorcaHi, but how specifying the actual date in the highlighted box?
- pmscorca
Hi,
I've solved specified this column and the related expression:
@formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ss')
In the lakehouse the actual datetime column is created as a string/char type and not a date type.