In this episode, we're going to tackle a JSON array residing in a field in our Snowflake table. We'll walk through how to query the field so that we can extract the fields so we can display them like other fields in our query. Flatten can be really useful when you have a lot of JSON data in a particular field in your database. You can use flatten to target specific array fields in JSON, so you can display it and do things like join other tables etc. Let's go!

Related Videos:
How to Create a Scheduled Task in Snowflake Using Python
   • How to Create a Scheduled Task in Sno...  
Python on Snowflake - How to Delete Records from One Table Using an ID Column from Another
   • Python on Snowflake - How to Delete R...  
How to Connect Python to Snowflake using ODBC
   • How to Connect Python to Snowflake us...  
How to Stage Data in Snowflake
   • How to Stage Data in Snowflake  
Python on Snowflake: How to Get PyArrow Table Output From a Data Warehouse
   • Python on Snowflake: How to Get PyArr...  
How to Use Flatten to Query JSON Tabular Array Data in Snowflake
You are watching this one now!

Check out my easy time entry system for your business:
https://system.billzone.com/billzone

Join me on Patreon!
  / mackenziedataengineering  

Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...



Check out some tech (and support my channel!):
https://www.amazon.ca/shop/seanmacken...

Want the code from this video?
http://mackenziemackenzie.com/downloads

For developers looking for a new role, check out and sign up:
https://www.toptal.com/qKaO2b/worlds-...

Needing to hire technical resources for your project? Get the best:
https://www.toptal.com/qKaO2b/worlds-...

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
  / mackenziedataanalytics  
  / seamacke  
  / seamacke  
  / seamacke  
  / psmackenzie  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...

#dataengineering #snowflake #python