From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Unlock this course with a free trial
Join today to access over 24,400 courses taught by industry experts.
Querying JSON data - Snowflake Tutorial
From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Querying JSON data
- [Instructor] We'll head back to the familiar Snow Site interface in order to run our queries. First, let's do a very simple select star from Zomato restaurants to see what this table looks like. You can see from the result that we have exactly one column named JSON Data. And within this JSON Data column, every entry is a JSON structure representing a single restaurant. You can see the details of this JSON structure once you select a particular record and look at the JSON structure off to the right. It's possible to access individual fields in this JSON structure in your query. Select JSON data colon restaurant will display the values associated with the restaurant field in each entity. And this is what the values look like. We have a field named R a field named API key, average cost for two, et cetera. Select a particular record and expand this panel off to the right. and you can see the details of the object…
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.