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

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…

Contents