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

In this video, I discussed about loading csv file as Json with nested hierarchy using azure data factory mapping data flows.
Link for Azure Synapse Analytics Playlist:
• 1. Introduction to Azu...
Link for Azure Databricks Play list:
• 1. Introduction to Az...
Link for Azure Functions Play list:
• 1. Introduction to Azu...
Link for Azure Basics Play list:
• 1. What is Azure and C...
Link for Azure Data factory Play list:
• 1. Introduction to Azu...
Link for Azure Data Factory Real time Scenarios
• 1. Handle Error Rows i...
Link for Azure LogicApps playlist
• 1. Introduction to Azu...
#Azure #AzureDatafactory #DataFactory

[@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 ☺️

[@AnnuKumari-mo6gz]

Beautifully explained 😊 Thanks

[@WafaStudies]

Thank you 😊

[@deepjyotimitra1340]

Very nice video. 👌

[@WafaStudies]

Thank you ☺️

[@prashastmaurya7782]

Wafa, you're the best :)

[@WafaStudies]

Thank you ☺️

[@sravankumar1767]

superb bro.. nice explanation

[@WafaStudies]

Thank you 😊

[@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

[@nico_mano]

Thanks a lot for this video

[@NitinMathewGeorge]

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

[@epuriraghavendra3847]

can we post that json data to an api endpoint ?

[@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

[@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

[@sathishkumark8386]

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

[@anjaliawate5706]

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

[@asadamjad2360]

Use Flatten Transformer

[@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 ?

[@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

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

Can u pls help me to do this in python