1. How to load Tabular and Hierarchical JSON data from Rest API to SQL Table | Azure Synapse | ADF

[@satijena5790]

Crystal clear explanation...without ambiguity. Great learning experience...Thank you Annu

[@azurecontentannu6399]

Thankyou so much 😊

[@harshitagrwal9975]

can you bring end to end project once.. ur explanation is to the point

[@FarhanSayed-j3z]

Great Explanation! Very helpful

[@amitgorai5553]

Superb content. It helped me a lot. Thanks and keep teaching. 😊

[@azurecontentannu6399]

Thankyou 🙂

[@rajeevranjan5913]

Very insightful.. Superb video.. Learnt some techniques which will surely help me down the line 🙏🙏

[@azurecontentannu6399]

Thankyou so much 😊

[@lopu8000]

@@azurecontentannu6399 what to do when during parallel copy data execution the source API gives gateway busy error

[@WafaStudies]

Nice 😊

[@azurecontentannu6399]

Thank you so much 😊

[@hellokajal6381]

Found informative.. keep uploading such videos

[@azurecontentannu6399]

Thankyou so much 😊 will try to be consistent

[@acsrr4288]

@@azurecontentannu6399 Hiiii were you able to see my previous comments? Please help... thx a million!!

[@azurecontentannu6399]

@@acsrr4288 no m not able to see ur previous comment

[@acsrr4288]

@@azurecontentannu6399 Hiii Annu could you see my reply now? thanks!

[@AshishKumar-qk9rc]

Great Content

[@azurecontentannu6399]

Thankyou 😊

[@kuzhalkannan6835]

Great work, appreciated.

[@rajdakash]

Informative

[@azurecontentannu6399]

Thankyou 😊

[@boggalanagaraj5478]

Hi Annu, its a very helpfull video and we need the video by using any one of the authentication insted of Anonymous like Basic or OAuth2 authentication.

[@sureshmekala2828]

Nice explaination

[@vijendraboipai5167]

👌👌👌

[@azurecontentannu6399]

Thankyou 😊

[@rohithnamani9614]

Thank you so much for the video. Do you know how to copy Tabular JSON into only 1 column in a SQL table using ADF copy activity.(Column datatype is Variant or Object)

[@kastenivkimbo5347]

Is this for Azure data engineer or visualisation tool developer / data analyst?

[@azurecontentannu6399]

Azure data engineer

[@kastenivkimbo5347]

@@azurecontentannu6399 I had one question: Is ADF a better ETL tool than SSIS? Are all the etl transformations available in ADF as its in SSIS or more ?

[@lucadelicio9883]

It's possible to map more tables calling only once API REST? How? Or the only way is to create 20 DaSet for 20 table in the JSON? Thank you very much!

[@azurecontentannu6399]

You can use parameterized dataset for both source and sink to achieve the requirement

[@satijena5790]

Hi Annu, Are you doing these playlist as an individual capacity or for a company? I have a project requirement that i wanted to discuss. Is there any contact you can possible share?

[@azurecontentannu6399]

Hi sorry it's out of my personal interest .

[@shaktipadadash4776]

Hi Annu, Thanks at first for the great content. Could you please help me to know what way we can use the same requirement if the data volume is high, i.e. 10K plus records needs to be copied. When I try the same way you taught here, there is performance issue and it takes hours. So any suggestion on this.

[@azurecontentannu6399]

Hi Shaktipada You can try increasing DIUs and DOPs in copy activity settings . Also, you can try using SHIR instead of AutoresolveIR.

[@blablastay]

Self Hosted IR can also scale up to 4 node cluster in case high volume date

[@azurecontentannu6399]

@@blablastay yes u r right

[@dataengineerazure2983]

@@azurecontentannu6399 Small question: Is it possible to put titles in addition to the technical name of the columns in the table in Azure. For example: code --> Folder number. I would like to have the 2 names (code, folder number) for example to do an analysis on Power BI. Thank YOU

[@azurecontentannu6399]

Hi @@dataengineerazure2983 , From where do you want to retrieve the folder number?

[@meeradesai4141]

can you give me some files which you use it for practice of synapse

[@azurecontentannu6399]

Hello Meera. You can google search for Sample REST APIs .. you will easily get some sample data to work with. Thanks for watching the video

[@deepak0417]

How about incremental load, like real time data update in API.