33. Load CSV file in to JSON with Nested Hierarchy using Azure data factory

[@MaheshReddyPeddaggari]

Thanks Maheer and i met your one of your best friend Dheeraj. I am also from his native place. This world is so small.
Thanks for your efforts

[@WafaStudies]

Oh great. Ya Dheeraj told about u.Dheeraj is very close and best friend of mine 🤗

[@MohammedKhan-np7dn]

Thank you Maheer, I was looking for this scenario to build nested level json out of CSV file format.

[@WafaStudies]

Welcome 🤗

[@shaksrini]

😀Derived column and Aggregator usage 👍👍👍👍

[@WafaStudies]

Thank you ☺️

[@NitinMathewGeorge]

Can the same be done using pipeline instead of data flow?

[@AnnuKumari-mo6gz]

Beautifully explained 😊 Thanks

[@WafaStudies]

Thank you 😊

[@prajju8114]

Hi Maheer, I have a question, Can we load csv files directly into cosmos db using copy activity or do we need to mandatorily convert it into json?

[@WafaStudies]

U can load. ADF automatically places in cosmosdb

[@prajju8114]

@@WafaStudies ok thank you so much

[@phalvin93]

This was helpful 😃. How if we would want to do the opposite -> transform json to csv?

[@WafaStudies]

U can use flatten transformation. Pls check flatten transformation video from my adf playlist

[@AlexAlex-kd6nj]

Nice explanation! But at the end of the video, the JSON file doesn't contain the root element.
So, if you put received data into any JSON Validator you will receive an error "Multiple JSON root elements".
Could you, please, explain how to put all objects in the [] separated by a comma?
Thank you!

[@none1615]

Hi , did you find a solution for that ?

[@sathishkumark8386]

Is there any help available regarding REST API for Blob and Data lake

[@Lokan30]

Does anyone know how to create a valid JSON structure output from ADF? This example creates JSONLINES which is not a valid JSON structure

[@epuriraghavendra3847]

can we post that json data to an api endpoint ?

[@nico_mano]

Thanks a lot for this video

[@sravankumar1767]

superb bro.. nice explanation

[@WafaStudies]

Thank you 😊

[@deepjyotimitra1340]

Very nice video. 👌

[@WafaStudies]

Thank you ☺️

[@saikrishnam382]

Hi bro i have 10 tables in "dbo" And 6 tables in "dim" Scheme. (In SQL Server)
I want to load 5 tbls from dbo & 3 from dim schema in dynamically. (Load into Azure SQL)
How can i accomplish this task.

[@pranamsharma3949]

U solved this problem? i am getting the same problem, can you help me

[@pranamsharma3949]

wafa studies , can you please help

[@anjaliawate5706]

i want to do reverse here i have in Json but i want the data flatten

[@asadamjad2360]

Use Flatten Transformer

[@S.h.iv.an.i]

Can u pls help me to do this in python

[@prashastmaurya7782]

Wafa, you're the best :)

[@WafaStudies]

Thank you ☺️