Getting started with Snowflake PT-3: Running queries and using JSON

In this video we go through using and running analytical queries in Snowflake. We will continue to use the web interface but the same queries will work in any tool. We also take a look at semi-structured data formats, specifically JSON with it's support for flexible schemas. We will build a database, load JSON data into it and query it without transforming the structure of the data using Snowflake's native capabilities.

Intro 0:00 Recap of previous video 0:39 Running some analytical queries 2:25 Run the first analytical query 5:49 Analysing the query 9:35 The Snowflake Cache 11:25 Run one more query 14:53 Cloning a table in Snowflake 16:37 Section summary 21:19 Creating a database for Semi structured JSON data 24:57 Create a stage for semi structured data 29:07 Load semi structured data from AWS S3 into Snowflake 30:55 Previewing our semi structured data in the table 32:17 Creating a view on on semi structured data 34:21 Running an analytical query from our view 39:04 Joining our semi structured data to our structured data 40:54 ... https://www.youtube.com/watch?v=04X0TrFPdhU