Search code examples
azureazure-data-factoryunix-timestampazure-eventhub

Azure Data Factory convert EnqueuedTimeUtc to Unix timestamp

I have a Data Flow that gets data from an EventHub.

enter image description here

The events have a system property called EnqueuedTimeUtc:

enter image description here

I want to convert the value of EnqueuedTimeUtc to Unix timestamp or at least to DateTime in Data Factory.

There's aso a property called SystemProperties. It has a property called x-opt-enqueued-time. I want to get the value of x-opt-enqueued-time as a column.

enter image description here

But if I try to Parse the SystemProperties column I got the following error:

enter image description here

Is there a way of doing this?

Thanks!

Solution

  • toTimestamp('04/12/2022 08:40:39 PM','MM/dd/yyyy HH:mm:ss') - toTimestamp('1970-01-01 00:00:00.000', 'yyyy-MM-dd HH:mm:ss.SSS')