Blob to ADF to Stored proecure

  • SQL_Surfer

    SSCrazy Eights

    Points: 8088

    I'm reading file from BLOB through ADF and I would like to pass the whole content of the file to stored procedure..Is it possible? If so,  can somebody give me some pointers? Thanks.

  • SQL_Surfer

    SSCrazy Eights

    Points: 8088

    I am using Lookup Activity to connect to Source file and trying to pass the whole content of the file through parameter of stored proc as a string. Stored proc loads the content to the table.

    But this is what's being loaded in the table instead of the content of the file.

    System.Collections.Generic.Dictionary`2[System.String,System.Object]

    Any idea would be appreciated.

     

  • xsevensinzx

    One Orange Chip

    Points: 25558

    What I do is load data to maybe Azure Storage (BLOB) and read it in through Azure Data Warehouse using PolyBase that's connected to that Azure Storage bucket via EXTERNAL TABLES. The stored proc lives on Azure Data Factory and thus, can have params passed via Data Factory to where the output is a INTERNAL TABLE in Azure Data Warehouse.

    Flow

    Azure BLOB Storage -> Data Factory (exec sp) -> EXTERNAL TABLE (ext.) -> INTERNAL TABLE (dbo.)

    Infrastructure

    Azure BLOB Storage -> PolyBase -> Azure Data Warehouse -> The Entire WORLD!

    • This reply was modified 5 months, 1 week ago by  xsevensinzx.

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

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