How to Load JSON File From Blob Storage to a Row in SQL Table by Using Azure Data Factory

[@chiranjib1983]

hit by 4MB limitation on both getmetadata and lookup activities, any suggestions please?

[@mob43059]

Very useful! Right to the point, thank you

[@msksudheer]

You are rocking as always, thank you

[@ramjeeyadav9728]

not able to lookup large Json and ADF fails, is there any alternative?

[@sravankumar1767]

Superb explanation 👌 👏

[@Lifestyle-mf4fh]

I am getting Null value from 2nd row onwards. Only first row getting value in SQL table, but from 2nd row onwards to getting all Null value.

[@sravankumar1767]

If we select a SP when we click import it automatically displays the Input param y should we enter manually. Can you please explain

[@somenathchowdhury2237]

Its is very common in all over the internet to read data from JSON and load to SQL DB. Do you have any video regarding read data from SQL DB and and create JSON with nested array.

[@TechBrothersIT]

Hi. I think that I have a video. search on channel. I will create few videos on this. thanks for your message.

[@somenathchowdhury2237]

@@TechBrothersIT Hi, thanks for your response...Is it possible for you to send me the URL of that video

[@rtrs5413]

How to load data from json to sql columns can u pls make a video that

[@devops840]

Hi sir, Could you please show how to do upsert for Loading Multiple CSV Files to Multiple Tables According to File Name in Azure Data Factory

[@TechBrothersIT]

there is already video on that. plz see playlist