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

preview_player
Показать описание
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
Python on Snowflake - How to Delete Records from One Table Using an ID Column from Another
How to Connect Python to Snowflake using ODBC
How to Stage Data in Snowflake
Python on Snowflake: How to Get PyArrow Table Output From a Data Warehouse
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:

Join me on Patreon!

Demo of my BZ RDP Cloaker:

Check out some tech (and support my channel!):

Want the code from this video?

Interested in transforming your career or finding your next gig?

Want my team to do a project for you? Let's get to it!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#dataengineering #snowflake #python
Рекомендации по теме
Комментарии
Автор

Thanks Sean! Keeping us access devs open to other possibilities with the snowflake series.

miles
join shbcf.ru