Import JSON file through ADF (from blob to SQL DW)

  • SQL_Surfer

    SSCrazy Eights

    Points: 8075

     

    My task is to import JSON file into SQL table using ADF.

    What am I doing wrong while importing JSON to SQL table? I've attached JSON file and code from ADF. I'm using Copy activity in ADF pipeline.

    It looks like only the first row gets imported. How can I tell ADF mapping to go to next set of data? Is it even possible to do so?

    I've attached the files that may be helpful for you to figure out what the issue could be.

    Any help on this would be much appreciated as I'm going nuts over this.

    Thanks in advance.

     

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

    Mr or Mrs. 500

    Points: 562

    Is it required to read the file using ADF?  There are a few ways to do it with just Sql Server (and without ADF).   The Json could be read from blob storage (as an external data source) using a combination of OPENROWSET (into nvarchar(max)) and then CROSS APPLY using OPENJSON.

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • SQL_Surfer

    SSCrazy Eights

    Points: 8075

    Yes. Only ADF is allowed at this point. Thanks.

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

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