locked
Fetch Multiple Files from Azure Blob Storage into SQL Server using OPENROWSET RRS feed

  • Question

  • Hello Everyone, 

    Currently, i fetch a JSON file from Azure Blob Storage using the following code,

    SELECT CAST(Bulkcolumn AS NVARCHAR(MAX)) AS JSONDATA
        FROM 
        OPENROWSET(BULK 'jsonbcontainer/pm_project_01.json'DATA_SOURCE = 'Azure-Storage'SINGLE_CLOB) AS Azure_BLOB

    I store this in a CTE and use OPENJSON() to parse and store the required columns in a target table. 

    Requirement:

    I would like to fetch multiple JSON files, one at a time(recursive read) and parse & store the data in the Target. Is there a way i can accomplish this using same OPENROWSET or any other way ? 



    Tuesday, May 26, 2020 6:37 AM

Answers