Hi, I have a SNOWFLAKE table with the column "JSON_DATA" that contains all of the meta data. this table gets updated by records submitted by another website. i can parse most of the JSON can create custom columns and extra the values in a SNOWFLAKE view for the exception of a nested object with in another nested object and it has an dynamic ARRAY. some times it is one value because in the web form it is a dynamic repeatable table this ARRAY can have up to 20 values but instead of coma separated values, the object repeats it self multiple times. I can not parse those values. i Need help i looked at this view since the topic is "complex and dynamic JSON data" my JSON are a lot more complex than what this video covers. need help.
How can you iterate a list within a json? You are using the indexes manually all the time but not showing how to iterate through them (without manually inserting the index)
For that you have to use flatten function.. that is covered in future chapters Download these two cheat sheet for your reference ➥ Complete Snowflake Tutorial rebrand.ly/maj4l6x ➥ Complete Snowflake JSON Guide rebrand.ly/d52cef
Is there a way where you can get all the element names both nested and non nested from the json in Snowflake? It can be only seen that we have to always mention the element names to get their values? Can it not be done dynamically? I mean getting all the key names from the json document?
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
This is very comprehensive!
Excellent!
Super helpful! Thank you!
Hi, I have a SNOWFLAKE table with the column "JSON_DATA" that contains all of the meta data. this table gets updated by records submitted by another website. i can parse most of the JSON can create custom columns and extra the values in a SNOWFLAKE view for the exception of a nested object with in another nested object and it has an dynamic ARRAY. some times it is one value because in the web form it is a dynamic repeatable table this ARRAY can have up to 20 values but instead of coma separated values, the object repeats it self multiple times. I can not parse those values. i Need help i looked at this view since the topic is "complex and dynamic JSON data" my JSON are a lot more complex than what this video covers. need help.
unable to see the insert statement you ran for the complex json queries. can you please share the same
How can you iterate a list within a json? You are using the indexes manually all the time but not showing how to iterate through them (without manually inserting the index)
For that you have to use flatten function.. that is covered in future chapters
Download these two cheat sheet for your reference
➥ Complete Snowflake Tutorial rebrand.ly/maj4l6x
➥ Complete Snowflake JSON Guide rebrand.ly/d52cef
Is there a way where you can get all the element names both nested and non nested from the json in Snowflake? It can be only seen that we have to always mention the element names to get their values? Can it not be done dynamically? I mean getting all the key names from the json document?
can you please add the video on how to parse the same in Big query tables.
Why don’t you upload the datasets for better understanding and practise