Working with JSON in Snowflake

[@KahanDataSolutions]

Deliver more impact w/ modern data tools, without getting overwhelmed See how in The Starter Guide for Modern Data → www.kahandatasolutions.com/guide

[@archen007]

exactly what I was looking for, quick and clear. thanks, man

[@KahanDataSolutions]

You bet, thanks for watching!

[@simba09911]

This video is super helpful, thank you for sharing!

[@adityagupta-mf9dt]

Very nice, I like the crisp and clear video 👏

[@SandipanSarkar-c8v]

finished watching

[@YEM_]

Would like to see some content on recursive parsing of JSON.

[@VaibhavSingh-ll5pd]

Hi, thanks for this video...I have a doubt... need your help when I do table(flatten(DATA,'context')) AS CONTEXT, table(flatten(CONTEXT.VALUE,'objects')) AS OBJECTS, It skips the whole of CONTEXT array when the OBJECTS array is empty, what is the solution for this? I want empty arrays as NULL where ever it is empty.

[@payaljindal1621]

Hi How I can query Json in snowflake if path contains hyphen(-) example {"total-blocking-time":{"id":"1"}}

[@lorenmurphy9387]

Hey, love your videos and I have been learning a ton from you. What would I do if I have a public API in JSON format? I want to use Snowflake to create some schema and run dbt in Snowflake to model against these.

[@KahanDataSolutions]

Thanks Loren! I would suggest first creating a pipeline to land the JSON data into Snowflake and having it stored as the "variant" data type. You can use a tool like Fivetran, create a python script or something else (up to you how you do that). Then you can run dbt against that raw variant data to create new transformed data models.

[@rwish]

How flatten after from table is working to reference value in select 😵‍💫, I’m drunk enough now loosing my marbles over this

[@SandipanSarkar-c8v]

finished watching