From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Join today to access over 25,600 courses taught by industry experts.
Load and query JSON data - Snowflake Tutorial
From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Load and query JSON data
In this demo, we'll see how we can load and query semi-structured data in the JSON format. We'll continue using the practice warehouse and we'll use the MISCDB that we set up in an earlier demo. Now the JSON data that I'm going to load in will be stored in the Zomato Restaurants table. I create the Zomato Restaurants table with a single column with the name JSON data of type Variant. Here, we have a single column of type Variant means that we are using a schema-less ingestion strategy for our JSON data. Our entire semi-structured document will be stored as a single entry in one column. This is a standard extract-load-transform approach in Snowflake, where we load raw JSON data into a single variant column to preserve the original structure of the data. We'll then query the data using its original structure. I'll upload the JSON data that I have on my local machine to the MISC stage that we had set up earlier. Click on Plus Files and drag and drop the ZomatoData.json file onto this…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.