Getting started with Snowflake PT-3: Running queries and using JSON скачать в хорошем качестве

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

My Courses on Linkedin Learning:   / tim-ngwena   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 Share feedback and Suggestions: https://tableautim.canny.io/suggestions - - Join this channel to get access to perks:    / @tableautim   ---------- (C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.