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 Share feedback and Suggestions: https://tableautim.canny.io/suggestions -
-
Join this channel to get access to perks:
https://www.youtube.com/channel/UC7HYxRWmaNlJux-X7rNLZyw/join ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.
Видео Getting started with Snowflake PT-3: Running queries and using JSON канала Tableau Tim
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:
https://www.youtube.com/channel/UC7HYxRWmaNlJux-X7rNLZyw/join ----------
(C) 2023 TN-Media LTD. No re-use, unauthorized use, or redistribution, of this video without prior permission.
Видео Getting started with Snowflake PT-3: Running queries and using JSON канала Tableau Tim
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
The MID Function in Tableau.Tableau Conference 2017 Las Vegas @ Mandalay BayInclude Level of Detail Calculation: Tableau FunctionsTableau Public Search - Find Tableau inspiration for anything.Replay animations: New in Tableau 2021.4Generate Rows in Tableau Prep : New in tableau 2021.3How to build Line charts in Tableau | Tableau ChartsAnalytics Extensions Explained with Aidan Moore | Data Science in Tableau & moreLet end users show and hide filters and more with this extension | What's new Tableau 2022.3Revealing the Future: AI's Impact on Data Analysts with Rahul Trehan - ChatGPT & AutoGPTAsk data updates in Tableau Server & Tableau Cloud: New in 2021.3How to do Dashed & Dotted Lines in Tableau | Line Patterns - New in tableau 2023.2Apache Log4J2 explained for Tableau usersTableau Developer tools: New in Tableau 2022.1 with Andre De VriesTableau Pulse - Metrics Unleashed | Announced at Tableau Conference 2023Google Analytics 4 Connector for Tableau | New in TableauTableau Visionary unboxing and thanks!Subscription emails for flow completion: New in tableau 2021.4Unified notification experienceRe-watch all of 2021, 2020 & 2019 conference on demand