Forum Discussion

Kudo Kingpin

2 years ago

Solved

Adding 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, please? Thanks

pmscorca
2 years ago
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.

4 Replies

NandanHegde
Super User
2 years ago
Similar to ADF, in data pipeline copy activity as well you can add additional column

https://stackoverflow.com/questions/68407493/adding-a-dynamic-column-in-copy-activity-of-azure-data-factory
- pmscorca
  Kudo Kingpin
  2 years ago
  Hi, but how specifying the actual date in the highlighted box?
  - pmscorca
    Kudo Kingpin
    2 years ago
    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
2 years ago
yes, you can use system variables and Functions to map to the additional columns .

So in your case UTCNow() and format it as per your needs