Dataflow Gen2 Fast Copy: Add timestamp column

[frithjof_v]

When ingesting data, we wish to add a "IngestedDateTimeUtc" column.

So we can keep track of when the data was ingested.

Currently, this is not possible with Dataflow Gen2 Fast Copy. Please make it possible 🙂 Thanks!

[miguel]

You can do this today by adding a custom column that leverages the function below:

DateTime.LocalNow - PowerQuery M | Microsoft Learn

You should be able to leverage this even when FastCopy is at play. Would you mind giving this a try and share with us your findings? 

[frithjof_v]

Thanks, I will try this once I find the time ☺️