Does ADF copy acitivity allow to format date using polybase.

Bharat Thatipally 21 Reputation points
2021-06-17T02:59:02.74+00:00

I have a bunch of files for which i can use copy activity from azure portal using polybase, but i have a date value coming as string which i am unable to convert to date format.
I have tried other options like data flow task which take more time compared to polybase. Any help in converting incoming string to date using polybase from adf portal?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
    2021-06-18T11:06:37.793+00:00

    Hi @Bharat Thatipally ,

    Welcome to Microsoft Q&A Platform. Thank you for posting your Query.
    To format Date values from source, use Copy activity Mappings tab and select Type as DateTime and define source format in it. Please check below screenshot for same.

    107062-copyactivitydateformat.png

    Hope this helps.

    -----------

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a email-notifications

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.