How to Use Flatten to Query JSON Tabular Array Data in Snowflake

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 https://youtu.be/vKaYmsdVwgY Python on Snowflake - How to Delete Records from One Table Using an ID Column from Another https://youtu.be/_cSAWZVwdHI How to Connect Python to Snowflake using ODBC https://youtu.be/XRKhns5Oi7g How to Stage Data in Snowflake https://youtu.be/9-1EEVPY22Y Python on Snowflake: How to Get PyArrow Table Output From a Data Warehouse https://youtu.be/RkAjBEeXjWs 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! https://www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link Check out some tech (and support my channel!): https://www.amazon.ca/shop/seanmackenziedataengineering Want the code from this video? http://mackenziemackenzie.com/downloads Interested in transforming your career or finding your next gig? https://system.billzone.com/careers.html Want my team to do a project for you? Let's get to it! https://buy.billzone.com/smdeprojects.html Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #dataengineering #snowflake #python