cross-apply nested JSON array

  • SQL_Surfer

    SSCrazy Eights

    Points: 8085

    I need to flatten out JSON file and load into SQL table. Under JSON settings, I don't see option to cross-apply nested JSON array in the source connection for JSON.  Do I need to turn anything on? I'm on DataFactory V2.

  • Site Owners

    SSC Guru

    Points: 80378

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • SQL_Surfer

    SSCrazy Eights

    Points: 8085

    Please look at both attached files. JsonJPG is from my computer and JSONJpg1JPG is from plural sight course. Why am I not seeing JSON option in my ADF?  Particulary Parse JSON, or CROSS join using JSON Nested array.

     

    Any insight would be appreciated.

    Attachments:
    You must be logged in to view attached files.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply