January 25, 2020 at 9:07 pm
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.
January 25, 2020 at 10:26 pm
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.
April 14, 2020 at 12:30 pm
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!
July 28, 2021 at 5:41 pm
I'm doing an HTTP GET and putting that output straight into a stored proc parameter using the reference below.
@activity('myHttpGetTask').output.Response
December 24, 2022 at 2:07 pm
How to get data from Azure Log Analytics workspaces and Azure Resource Graph explorer into Azure SQL Database ?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply