Believe me or not but I needed tutorial like that. I work on a project where I need to parse huge amount (3000+) flies and that contain very complex JSON structures and regarless of my previous experience with JSON as such I have almost gave it up. this tutorial helped me a lot. Thank you very much!
thank you, it is really helpful, in my case i have just one problem : i have multiples columns with the same name like "id" with different level (nested json) and different values, that's generate an ambiguity between all attributs with the same name, i found for instance one in your script (title) which has the same name and same value, any help !?
I realize this is a response to a months old question, but I just worked through the same problem, after finding this tutorial. Maybe it will help someone. You just need to specify the table with the column. When you cross apply, you assign a different table to each tier/object. For example, SELECT TableA.ID, TableSnippet.ID, etc. to differentiate the same column names.
Exactly what I needed - excellent demo!
Great example of parsing a complex JSON tree. Thanks!
Well Explained with good example...Thanks
Believe me or not but I needed tutorial like that. I work on a project where I need to parse huge amount (3000+) flies and that contain very complex JSON structures and regarless of my previous experience with JSON as such I have almost gave it up. this tutorial helped me a lot. Thank you very much!
Spent hours trying to figure this out. So glad this video exist!!!!
Glad the video helped!
This is an excellent video tutorial covering major things regarding JSON Parsing. Thank you so much!
Great class.
Keep up the good work.
Thank You,
Natasha Samuel
Muito obrigado. Seu tutorial me ajudou muito, agradecimentos do Brasil.
You help me a lot. Thanks a lot!😀😀😀
👍
I tried it but while parsing the records I got only the first record in result. Please help
Where can you download the JSON in this video?
This is brilliant stuff.
Bro how to get all column in dynamic
where to download the json file and this code.? please let me know.
Thank you !
Hi Jie Jenn- Can u please share the Final query which you have used in this tutorial?
Don't have the script anymore.
I have prompted with Error:
Must declare the scalar variable "@json_table".
sorry..my mistake i was on remote server and file path is located local system.
thank you, it is really helpful, in my case i have just one problem : i have multiples columns with the same name like "id" with different level (nested json) and different values, that's generate an ambiguity between all attributs with the same name, i found for instance one in your script (title) which has the same name and same value, any help !?
I realize this is a response to a months old question, but I just worked through the same problem, after finding this tutorial. Maybe it will help someone. You just need to specify the table with the column. When you cross apply, you assign a different table to each tier/object. For example, SELECT TableA.ID, TableSnippet.ID, etc. to differentiate the same column names.
@@captainmoonrock
Is this video show how to set up automate pipeline from json source into staging or data warehouse?
Thank you , without as json its show NULL help
Getting error as incorrect syntax near openrowset
Fix your syntax.
@@jiejenn suggest if anything's wrong
@@jiejenn I had one more question, does the code support in azure synapse data warehouse?