Dynamically Add a Timestamp To Files in Azure Data Factory


This article will describe how to add your local timestamp at the end of the each file in Azure Data Factory (ADF). In general, ADF gets a UTC timestamp, so we need to convert the timestamp from UTC to EST, since our local time zone is EST.

For example, if the input Source file name in SFTP is « _source_Customer.csv », then the expected outcome will be, « _source_Customer_2021-02-12T133751.csv ». This means that the pipeline should add ‘_2021-02-12T133751’ to the end of each file. This will work dynamically, which means that any file you pass from the source will have the timestamp added to