Snowsight - Snowflake Modern Web UI | Chapter-5 | Snowflake Hands-on Tutorial
HTML-код
- Опубликовано: 30 июн 2024
- Snowsight - snowflake Modern Web UI Tutorial (Chapter-5) covers every function & feature of snowsight thin-client. Starting from the worksheet, folder, filter, sharing, dashboard and visualisation, and many more features are described in detail along with the hands-on guided tour.
Snowsight's dashboard is sometimes compared with the Tableau dashboard (Snowsight vs Tableau) or PowerBI dashboard (Snowflake vs PowerBI) as it has a lot of powerful features and also supported sharing capabilities with other stack holders within the organisation.
The snowflake snowsight preview app brings a lot of productivity to the developer community and also makes the overall navigation very smooth and sleek.
So enjoy this video series and provide your valuable feedback.
🌐 Site: toppertips.com
🚀 🚀 Chapters 🚀 🚀
-----------------------------------------
➥ 00:00 Why and Why Not Snowsight
➥ 00:45 Welcome Note
➥ 01:08 Episode Syllabus
➥ 02:34 Why to subscribe
➥ 02:14 Snowsight quick feature review
➥ 04:26 Live Demo - How to access
➥ 05:37 Live Demo - Feather Map (All Menus)
➥ 08:40 Live Demo - Profile
➥ 10:12 Live Demo - Worksheet
➥ 18:18 Live Demo - Worksheet Formatting
➥ 18:40 Live Demo - Worksheet Filter
➥ 22:32 Live Demo - Dashboard
➥ 24:49 Live Demo - Dashboard Filter
➥ 26:50 Live Demo - Data
➥ 31:25 Live Demo - Compute
➥ 34:37 Live Demo - Accounts
➥ 38:36 Live Demo - Classic Console & Switch Account
➥ 39:54 Quick Recap
➥ 40:36 Quiz Time
➥ 44:15 Learning in this episode
➥ 44:37 Thank you note & next chapter
➥ 45:11 Disclaimer
🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀
---------------------------------------------------------------------------------------------------
➥ Chapter 1-to-25 "Complete Playlist" 🌐 bit.ly/3iNTVGI
➥ Chapter-1 Snowflake Introduction & History 🌐 bit.ly/3xKHrna
➥ Chapter-2 Snowflake Free Trial Registration 🌐 bit.ly/3m6uiCL
➥ Chapter-3 Snowflake Architecture 🌐 bit.ly/3sk2fB2
➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 bit.ly/3stSyzS
➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐 • Snowsight - Snowflake ...
➥ Chapter-6 Snowflake Unique Features 🌐 • Snowflake Unique Featu...
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 • Snowflake Database/Sch...
➥ Chapter-8 Snowflake Must Know Database Objects 🌐 • Snowflake Must Know Ne...
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 • Fast Data Loading & Bu...
➥ Chapter-10 Snowflake Continuous Data Loading 🌐 • Continuous Data Loadin...
➥ Chapter-11 Snowflake External Table 🌐 • How to work with exter...
➥ Chapter-12 Snowflake Virtual Warehouse 🌐 • How To Work With Snowf...
➥ Chapter-13 Snowflake Micro Partition 🌐 • #13 | Micro Partitions...
➥ Chapter-14 Snowflake Time Travel 🌐 • What is Snowflake Time...
➥ Chapter-15 Snowflake Clone Feature 🌐 • Snowflake Zero Copy Cl...
➥ Chapter-16 Snowflake Secure Data Sharing 🌐 • Snowflake Data Sharing...
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 • Snowflake Stream & Cha...
➥ Chapter-18 Snowflake Task & Task Tree 🌐 • Snowflake Tasks & Task...
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 • ETL Workflow In Snowfl...
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 • Role, Grants & Role Hi...
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 • Stored Procedure In Sn...
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐 • User Defined Functions...
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 • What are views in Snow...
➥ Chapter-22 Snowflake Information Schema 🌐 • What Is Information Sc...
➥ Chapter-23 Snowflake Resource Monitor 🌐 • What Is Resource Monit...
➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐 • How to Use Snowflake J...
➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐 • Microsoft Excel & Snow...
➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 • Snowflake Python Conne...
➥ Chapter-25 (Part-1) Snowflake & PowerBI Reporting 🌐 coming-soon
➥ Chapter-25 (Part-2) Snowflake & Tableau Reporting 🌐 coming-soon
🚀 🚀 Snowflake Certification Complete Guide & Question Dump 🚀 🚀
-----------------------------------------------------------------------------------------------------------------
➥ Revised Sep 2020 Syllabus: • Video
➥ SnowPro Guide: bit.ly/35S7Rcb
➥ SnowPro Practice Test (60 Questions): bit.ly/2Ubernv
#snowflakewebui
#snowflakesnowsight
#snowsight
#snowflaketutorial
#snowflakecomputing
#snowflakedatawrehouse
#snowflake
#dataengineeringsimplifed
#clouddatawarehouse
#snowflakelegacyWebUI
#snowflakemodernwebui
#snowsightvspowerbi
Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.
omg snowflake is such a great technology, they are single handedly covering data analyst and bi with those features
Yes, snowflake is the future when it comes to cloud data warehouse and soon it will put lot of competition in the market. I really love this techology.
Snowflake should hire you, incredible walk through man
Thank you for creating an easy path for us. Snowflake is ever changing, many updates have been added to snowsight within a year.
Thanks for sharing! and Yes it is changing a lot and I will make another video on Snowsight.
When I am logging in now, i see alot of differences in SNowflake UI and i able to see and match the difference. Thansk
Snowsight usage is clearly explained. Thank you.
Thank you 🙏 @Murali Krishna for watching my video and your word of appreciation really means a lot to me.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
This is an outstanding effort with such a rich content !! Kudos to your effort :)
Glad you liked it!!
and yes, I know many of us are not fully aware of snowpark Python API, if you want to manage snowflake more programatically.. you can watch my paid contents (data + code available) .. many folks don't know the power of snowpark... these 2 videos... will help you to broaden your knowledge..
These contents are available in discounted price for limited time.. (one for JSON and one for CSV).. it can automatically create DDL and DML and also run copy command...
1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/?couponCode=DIWALI50
2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/?couponCode=DIPAWALI35
www.udemy.com/user/data-engineering-simplified/
The Way you teach and content you provide really its Astonishing.
glad you liked it..
and yes, if you want to manage snowflake more programatically.. you can watch my paid contents .. many folks don't know the power of snowpark... these 2 videos... will help you to broaden your knowledge..
These contents are available in discounted price for limited time.. (one for JSON and one for CSV).. it can automatically create DDL and DML and also run copy command...
1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/?couponCode=SPECIAL50
2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/?couponCode=SPECIAL35
Really a great effort.. thanks for doing to build the community
Thank you @Sadrul Alom 🙏 for watching my video and sharing your feedback and your word of appreciation really means a lot to me.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Thank you for Creating this Videos it is really helpful for learning
amazing series, please upload more videos i am planning to give snowpro core exam in 2 weeks, and i guess your youtube videos are suffiecent
Thank you 🙏 @Hemant Patil for watching my video your word of appreciation really means a lot to me. Wish you all the best for your exam.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Good stuff! my man, great job! Thank you so much!
Thank you 🙏 for watching my video and your word of appreciation really means a lot to me.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Thank you for the tutorials. :)
Glad you like them!
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Awesome tutorial , that too for free. Thank you so much Sir !!
You are welcome!
You can find all the important link for the different videos by using these cheat sheet
🚀🚀 Cheat Sheets 🚀🚀
➥ Complete Snowflake Tutorial rebrand.ly/maj4l6x
➥ Complete Snowflake JSON Guide rebrand.ly/d52cef
Your videos are very helpful. Thanks for sharing.
Glad you like them!
This is so awesome. Simple and Easy to understand. An Honest review. I found this video series by luck when I was searching for study materials to prepare for Snowflake. This is going to help me a lot. I have purchased a course from Udemy but to my luck it didn't help me. Thank you for all the efforts.
Glad you enjoyed it!
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
@@DataEngineering yes i have started with this series. I'll complete one by one. Thank you 😊
Thanks For Valuable Content-❤
Keep watching
Amazing Video. Please create more video on this Snowsight UI, specially on Reporting Purpose like Dashbord,filters.
Thank you 🙏 @Mayur for watching my video and your word of appreciation really means a lot to me.
SnowSight complete series will be out soon. Keep watching this space and you could possibly subscribe so you will get the notification.
Super easy way of explaining 👏👏👏
Glad you liked it
Nice videos, loved the content and way the concepts are explained
Thanks a lot 😊
it is very useful. i searched many videos u r awesome
Glad to hear that
really super !! never seen like this tutorial
Glad you liked it!
Amazing explanation.
Glad you think so and thank you 🙏 @Himanshu Mittal for watching my video and your word of appreciation really means a lot to me.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Great overviews!
Thank you 🙏 for watching my video and your word of appreciation really means a lot to me.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
is awesome... tks to share
Thank you 🙏 for watching my video and your word of appreciation really means a lot to me.
Thank you 🦋
You are so welcome
Excellent explanation
Glad it was helpful!
Thanks you for making learners life easy
Good luck!
Thanks for the amazing content and delivery!! I am very new to the snowflake, so not sure whther I am missing something here... In the classic web ui, if we create any object, say for eg. Warehouse, database, tables or etc..we havea chance to see and copy the sql for the same action but I cant find that option in snowsight :(. Am I missing something? Your response will be haighly appreciated!!
Welcome aboard!
There is a copy icon even in snowsight but a few of the features are missing in snowsigh as it is still in preview mode.
This I stumbled upon this tutorial on youtube while learning snowflake , it s a gem of a tutorial.
I have one question , where can i find the schema structure and data , could you please share the link ?
Thank you @yetanotheremail. I was also about to ask the same question
Amazing Explanation! Can you please share the feature maps of Classic & Snowsight WebUIs?
will try via my website
toppertips.com
Thank you for the informative video. I did not know about many of these features. Is there a UI to create and load tables as there is in Classic View? The create table tab in Snowsight is just SQL.
The new snowsight can do that.. it is in public preview.. and not yet made GA.
Hi, your videos are so great. Is that one needs to know all concepts like snow pipe and snow sight all to work on snowflake? Thanks
Well.. it dependes.. if you don't know these concepts.. then Snowflake is equal to SQL... like oracle or mysql..
Awesome video😇... But I had a question..... Does Query History shows results of last 14 days as Classic Console does?
Yes it does!
Thank you for your videos. I have become an interested in Snowflake after watching your videos. I want to know is it possible to get Snowflake certified if one has not worked on Snowflake in his/her job? Are there questions in exam that require hands on experience?
Q1: I want to know is it possible to get Snowflake certified if one has not worked on Snowflake in his/her job?
A: Yes, you don' t need any prior experience. You need to spend more time playing with free trial edition and you will surely clear the exam.
Q2: Are there questions in exam that require hands on experience?
A: No, you must know basics of Data Engineerings and basic of clouds.. but majority of the questions are theory based.
If you follow all my playlist chapter, you will 100% crack the exam in less than 3-4 weeks.
Awesome explanation, could you tell me that classic console is nothing but legacy web ui?
Thank you @RK.. yes classic console is legacy and soon it will be stopped and snowsight will become primary interface to access snowflake.
Question 8 has csv and tsv both in the snowsight version download option
@DataEngineering can you provide the link to the schema and if possible could you share the example data so that we can load and play with it in snowflake
Hi, I love your content but is there any chance I can have your feather map? Thank you so much!
Hi ,
Im learning snowflake newly to change my current domain, can you please also explain how real time scenario will be on snowflake?
Would request to watch Ch-19 from this playlist (studio.ruclips.net/channel/UCnfZSN7A09wNwYiUoincXZgplaylists)
Not sure when you say real time scenario? Could you elaborate or drop a note to my instagram acccount (instagram.com/learn_dataengineering/) with your domain problem and your experience, this helps me to answer it correctly.
Can we create multiple filters for dashboard but the result of 2nd filter is based on the selection of the 1st filter. For example if we have Regions and Market. Both are query based filter, but as soon as user selects Region, Market filter should now only display the list of markets with in that Region. Thanks
I never tried that.. but let me check..
Could you please share a vedio on how github version control and CI/CD works with Snowflake? Thank you for all the help..
Will make it soon.. thanks for sharing your query.
Thanks for the amazing informative video. I am studying snowflake and wish to do certification. Is it posible to download its contents? Do you have a website?
Thank you 🙏 for watching my video and your word of appreciation really means a lot to me. Most of the content are rich media and hard to share.. and there are many files which are used to build these contents.. but I try to make some of the hands on sql script via my website.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them.
🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI
🌐 SnowPro Guide ➥ bit.ly/35S7Rcb
🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq
🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E
@@DataEngineering Snow pro Question dump link is not working. By the way thanks for the amazing video
My UI is different. Though, not that much, but still, it's different..🤔
For e.g., there is no 'Classic Web Import' feature available inside my UI
Do you think these video are enough to pass the exam or do i have to buy udemy practice guide?
to some extend.. but you also need to refer snowflake's docs and other contents
I would suggest to go through this playlist which I had published sometime back - snowpro certification strategy
ruclips.net/p/PLba2xJ7yxHB6-w7PHPi-wvj1SdbrIjxk2
and yes, I know many of us are not fully aware of snowpark Python API, if you want to manage snowflake more programatically.. you can watch my paid contents (data + code available) .. many folks don't know the power of snowpark... these 2 videos... will help you to broaden your knowledge..
These contents are available in discounted price for limited time.. (one for JSON and one for CSV).. it can automatically create DDL and DML and also run copy command...
1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/?couponCode=DIWALI50
2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/?couponCode=DIPAWALI35
Your videos are with Legacy UI and I am not able to use the Legacy UI for me its only the latest version available. please suggest what to do?
snowsight is not legacy.. but yes the current snowsight has changed a lot.
Can u give some suggetion for fresher with career gap which course should i choose m doing data analysts course
yes, you can build your career in snowflake.. with basic to intermediate data engineering knowledge...
Hi, Very nice videos thanks for that. How can I change from new UI to legacy Web UI? I am unable to find it.
From Snowsight, go to the left botton and you will get a link called Classic WebUI.. when you click on it.. it will take you to classic webui.. you need to login again to access it..
8th question quiz, csv and tsv are available for result downloading format, you just mentioned only csv
yes.. you are right.. they have added more option in their recent release...
so i am a web dev and i need to create a sample application for snowflake using angular and js i didn't find any docs rearding this how can i buit this and is it possible to build can any one help me or provide me a doc for this issues
how to find that, when table is last refresh in snowflake for tables without date field
for that you have to use time travel feature.. watch time travel chapter in this playlist (ruclips.net/video/9k8ADXunhIk/видео.html)
For business analyst how much experience or knowledge is need of snowflakes???
you just need to know how to use snowflake and many be 2-3 weeks of education is good enough... and if you cover 50-60% of this playlist.. you will understand how this platform works.
How to get notes for all this videos or do we need to prepare on our own?
Working on them and will soon will make it part of video description.
Please provide us the notes you have explain here in this course!!!!
I cannot see the button to go to preview app. and my snwflake is very different from yours :(
When this video was released, the Snowsight was in preview mode, now it GA release..that's why it looks different.. I may have to release a new one with new look & feel ( it is not very different, but yes there are changes)
10:40, i don't have that import worksheet option.
i am also in account admin role.
if you have created newer account, legacy webui will not be enable, so there is no question of importing the data. Can you access the legacy web ui and do you have worksheet therer? if not, then this function will automatically be disabled or even not available in newer version of snowflake.
Hi
Nice Videos, but am not able to view Compute option in Snowsight. Can you please tell me how i can find this compute option in snowsight @Data Engineering Simplified
The left side panel is changed.. the compute is now known as activity and the warehouse menu is moved under admin main menu.
@@DataEngineering Thanks you sooo much...😊
can you make video on lastet snowsight ui?
let me review all the features and will release a revised one soon.. they are making many changes and too fast
Snowflake is another name of data ware house? Or it’s company name?
Snowflake is the name of the company as well as its data warehouse solution is also known as Snowflake... (like Oracle and Oracle Database)
@@DataEngineering thanks I am SAP BW consultant and wanted to know the benefits upgrading by learning snowflake where I can show the benefits to the company when we integrate with Sap BW. As SAp BW is pioneer tool currently in the market for large companies and is it possible to connect sap BW and snowflake? If yes please provide one session.
RECENTLY THEY REMOVED CLASSIC WEB UI NOW CAN YOU PLEASE TELL US HOW TO LODE DATA FROM CSV FILE TO A TABLE IN SNOWSIGHT
My following video can help you
1. ruclips.net/video/Ss76gupmc3w/видео.html - Loading CSV data using user stage.
2. ruclips.net/video/ygZ04M2YcKs/видео.html - Loading CSV data in snowflake
Thank you
i am not able to open classic console
classic console is deprecated... so it is no more available for new signups.