#05 | Query Complex & Dynamic JSON Data In Snowflake

[@KimShill-y8h]

Super helpful! Thank you!

[@nandithavyas]

unable to see the insert statement you ran for the complex json queries. can you please share the same

[@cloudlover9186]

can you please add the video on how to parse the same in Big query tables.

[@pmohantymohanty7]

Why don’t you upload the datasets for better understanding and practise

[@andonii46]

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)

[@DataEngineering]

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

[@amitlahiri5947]

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?