Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to Solution.
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.
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
Similar to ADF, in data pipeline copy activity as well you can add additional column
Hi, but how specifying the actual date in the highlighted box?
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.
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
3 | |
3 | |
3 | |
2 | |
2 |