Search code examples
azure-data-factory

Current Timestamp in Derived Column of Dataflow in Azure Data FActory

Inside my dataflow in Azure Data Factory, I want to have a derived column with current timestamp in Australian Eastern Standard Time (AEST) timezone (similar to getdate()) and use it as one of the columns to map in the sink.

enter image description here

How do i do that? I'm getting null when i refresh the preview

Solution

  • When I tried to repro I see the same thing

    enter image description here

    As a workaround you can try few options as below

    Use currentUTC('AEST')

    enter image description here

    Note: Data preview always shows in UTC. Check form the output dataset to be precise.

    enter image description here

    You can also use fromUTC(currentUTC(),'Antarctica/Macquarie')

    enter image description here

    enter image description here

    enter image description here

    Refer this notation: worked for me

    enter image description here