Post reply

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

  • January 10, 2020 at 3:59 am

    #3714215

     

    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.

  • January 10, 2020 at 3:24 pm

    #3714421

    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

  • January 10, 2020 at 3:26 pm

    #3714424

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

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

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