cross-apply nested JSON array

• SQL_Surfer

  SSCrazy Eights

  Points: 8085

  More actions

  January 13, 2020 at 5:28 pm

  #3715005

  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

  More actions

  January 14, 2020 at 6:10 pm

  #3715339

  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

  More actions

  January 16, 2020 at 3:25 am

  #3715866

  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.