#4 | Snowflake Classic Legacy WebUI | Snowflake Tutorial

[@andrey5837]

This free course is much better than a course i bought from udemy. Thank you very much my friend.

[@DataEngineering]

Glad to hear that @Andrey

[@bertiefret5353]

nice, the best things in life are free lol, Yes I confirm that this video is top class, good job@@DataEngineering

[@tapu4ujis]

Dear Tutor, This is a very clear tutorial on snowflake and I am telling this from my own experience of being a data Architect.

[@DataEngineering]

Thank you 🙏 @tapu4ujis 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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

[@JigarZone]

@@DataEngineering is this for students who r eager to learn this clod db

[@JigarZone]

@@DataEngineering plz release video rltd time travel

[@thumatisvaishnavi6789]

Now I see the Playlist is either deleted or made private 🤔 Is there any means of getting it?

[@poojadakhole6107]

Till now I have covered 3 videos. I will complete the others soon. I really like the way you have explained. Thank you very much for this snowflake knowledge.

[@DavidPalm-m5l]

Thank you! This version of the UI is deprecated to trials and new users but still useful. As you mentioned things change fast! I like the quiz at the end to recap what you taught.

[@DataEngineering]

Great to hear! my new playlist is recorded in Snowsight WebUI... you I am sure you would enjoy them..

[@BlackSwan912]

You are a pretty amazing individual. Thank you for these. Your time creating just one episode is quite long. Then you update the comments to notify us of updates to the actual application. You are busy, and I appreciate your efforts. At first I was concerned for audio - the sound is a bit low and almost muffled sounding, and of course to my American ears you have quite an accent. However, it's become less and less an issue by this 4th module. I'm getting used to it (that is a GOOD thing because I have a LOT of Indian co-workers!) and you also include a lot of text overlays that really help me to stay in tune. Again, MANY THANKS for what you have done here! As a former trainer, I applaud your efforts here and your end result. You've done a great job.

[@DataEngineering]

Thank you very much for the valuable feedback; it's greatly appreciated. I will definitely take all of your suggestions into consideration. While I'm uncertain if my accent will change soon...the majority of my audience is from India, so I will explore alternative solutions. Rest assured, I will address all the other technical issues from my next video onwards.

[@japref4939]

You have an amazing knowledge, and you are a very good teacher. I have subscribed your channel. The only guru dakshina 🙏 I can do is pass it to people.

[@DataEngineering]

So nice of you

[@rameshchidurala3822]

@DataEngineering I am unable to create a table under the database I have created. I am not seeing an option to create a table. When I try to create a table from the main page, it gives me four different options to create a table, but each option requires me to write an SQL query to create a table. It is not showing me an option to simply give it a name so it can write the SQL query in the backend. Could you please help me with this? Thanks. By the way, I am using the ADMIN account.

[@sunilkumar-ch4uc]

Dear Tutor, You are efforts to share Knowledge is very great, the Lessons are very Good , Thank you So much

[@DataEngineering]

So nice of you @sunil Kumar You can watch the entire playlist and more yet to come (bit.ly/3iNTVGI) 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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

[@sanjeev2012delhi]

Awesome!! Milestone tutorial and the way of presentation is marvelous.👍👍

[@DataEngineering]

Thank you 🙏 @Sanjeer Kumar 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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

[@prudhviraj7408]

Very Clear Cut tutorials , Thankyou .

[@DataEngineering]

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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

[@hariganesh.a9166]

Highly recommended. As interesting as watching a movie :)

[@DataEngineering]

glad that 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... this 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

[@anilar7496]

Nice tutorial and I forwarded it to my Data engineering team. Great job!!

[@DataEngineering]

Awesome, thank you!

[@vidhyalakshmi-o4v]

this free course will help to more people for their career upskilling.......................

[@rameshchidurala3822]

@DataEngineering I got account admin by default, Should I use that or do i need to switch it to system admin? I am confused.

[@thambiduraimanisekaran4731]

This set of videos are very useful for me to develop my knowledge in snowflake and helpful for the examination preparation. Very very thanks for you

[@DataEngineering]

You are most welcome

[@dhruvimandaviya7198]

Awesome video, I am learning new. Thanks for making this wonderful series 🎉

[@Coding-z1m]

since the verison of the snowflake UI is not matching did you face any difficulty?

[@rahamthullashaik9025]

sir ,your content is awesome , but now SNOWFAKE portal was changed ,will you pls videos according to new updated version ?

[@Options_Xpert]

Awesome!! the way of presentation is super.👍👍

[@DataEngineering]

Thank you 🙏 for watching my video and your word of appreciation really means a lot to me.

[@SurendraKapkoti]

Great learning tutorials.. thank you..🙏

[@udayrajd]

Current UI in the trial account looks much different e..g the wizard does not come up for creating a file format, it has to be done through sql. Is there any setting that i need to modify to get the UI wizards to create various objects ? Please advise. Thanks.

[@DataEngineering]

Yes, the old UI is no more available and you will be directed to new web ui

[@Ikramikram-vf6fb]

This is a very clear tutorial on snowflake, but can you please add the resources used in each videos (the files..) it'll be great to practice at the same time

[@DataEngineering]

will release the SQLs soon.. via my website..

[@souravburman3119]

@@DataEngineering Hello, really a great place to learn Snowflake. Kindly let us know, where can I find the resources?

[@rohitharava7155]

Excellent explanation ❤

[@DataEngineering]

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 udemy.. (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/ 2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/

[@pratikparbhane8677]

Thanks For Valuable Content ❤

[@DataEngineering]

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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

[@himanshumittal1095]

Very well explained.

[@DataEngineering]

Glad it was helpful!

[@sudipmazumdar5358]

Thanks a lot for such a comprehensive content !! For real time office projects, could you please throw some light on what edition is generally used or what kind of UI is being used ? Also how can we integrate snowflake with IICS ?

[@DataEngineering]

Generally enterprise edition is commonly used in many large organisation. The legacy UI is now stopped by snowflake and you will get access to SnowSight (the modern webUI) to access snowflake. Yes IICS can be integrated with snowflake.

[@sudipmazumdar5358]

@@DataEngineering thanks a lot 👍

[@reshma1473]

Hi sir, I would like to learn snowflake , is this playlist alone enough to learn snowflake ,any one please reply I’m a beginner. What else should be learnt to get job

[@Arrchitha]

Instead of default experience there is default role and warehouse what should I set up

[@ANKITVERMA42]

Thanks for the great video tutorial :)

[@DataEngineering]

Thank you 🙏 for watching my video @Ankit Verma 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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

[@svbhalaji]

The UI is different now in snowflake. Are these videos relevant to current Snowflake UI?

[@DataEngineering]

The legacy will soon be decommissioned by Snowflake and SnowSight is the new WebUI.

[@stephenokon3227]

Hello presenter. Thank you for your videos. I am new to snowflake and trying to follow your videos. I have a problem finding on my SnowSight interface, the Help button from the left hand corner where could download the drivers. The Snowflake UI you're using is totally different from the free trial version I downloaded using your lesson 2. This is making it pretty difficult for me to follow the course. What do you advise I do to get around this problem? Thank you in advance for your help.

[@amitjha9747]

yes same issue for me

[@MaherSoua]

@@amitjha9747 @stephenokon3227 you can switch to legacy web ui, he already talked about a new UI

[@pk-wanderluster]

Excellent lessons! what tool have you used to create diagram used in top left/right menus?

[@DataEngineering]

Thank you 🙏 @kadamp for watching my video and your word of appreciation really means a lot to me. I use braining storming mapping tool to draw those drawing, not sure if you are taling about those tree map?

[@big-bang-movies]

Thank you for such good content. If possible, please increase the volume little bit. Specially for people who has little hearing problem or watching these videos with background noise, it will be difficult to understand at this volume.

[@DataEngineering]

Thanks for the feedback Ryan.. in my recent videos.. I tried to avoid the background noise as well as supporting high volume in my newer video. If you still find issues for new videos, pls do report. For old videos, it is hard for me to replace them.

[@nagarjun4156]

Great content, thanks for sharing free...

[@DataEngineering]

Glad you enjoyed it!

[@jahnavij7047]

can you please provide the version of snowflake ?

[@apostleisaacopokuagyeman5676]

Great tutorial !!!

[@DataEngineering]

Glad you linked them.

[@amitjaiswal781]

Thank you for this videos.

[@DataEngineering]

Glad you like them!

[@syakirar2198]

Hi there! Thank you so much for your tutotrial. So far, I've learnt a lot about Snowflake. I had 0 knowledge on cloud stuffs and in just 3 videos from you (+chatgpt for vocab) I feel much more confortable going forward. However, I have a problem: when I log in Snowflake, I have the view/UI you have at 5:21 (the one where you click on "app preview") But I don't know where and how to access the view/UI you have at 6:01. Please tell me how to do this.

[@DataEngineering]

For new snowflake accounts, it looks like the legacy web page is no more accessible... else to access the legacy webui, you have to go to profile link from your snowsight page and change the preference to land to legacy webui

[@syakiraramli5536]

@@DataEngineering I'm sorry, I don't understand. What is the profile link and where can I change the landing page? It should be in some sort of settings right? But I don't have settings in the Snowsight page???

[@Priyanka-us8rw]

This playlist videos is more likely for data engineer role.. But may i know how much use for business analyst role??.. Or i have to go through all videos of your playlist?

[@DataEngineering]

Yes, this playlist is primarily for data engineers and not targeted for business analysis... I have never got any request from business analyst.. may be ch-5 of this playlist may be useful as it talks more about snowflake snowsight user interface.

[@nikunjtibdewal6846]

HI videos are very details and very helpful. just one question, is there anyway you can provide study material and the code used during training so that we can download and use as reference.

[@DataEngineering]

Thanks Nikunj, The content used are rich media and it is not just one item..there are lot of things to build the contents... I prefer to share the summary via my blog .. will see how can I build summary for this chapter .

[@AMALsjalwn]

I am getting a different UI altogether..🤔

[@DataEngineering]

Yes, watch next chapter... where Snowsight WebUI is become the default WebUI.. and this WebUI is called Legacy WebUI and no more available to new users.

[@b.chaitanyadas1797]

Hi recently i created the SFK account and your UI and my UI is different.If i want load the data from csv from my local i am not getting the LOAD DATA option.what is the reason?

[@DataEngineering]

Yes, the UI has been chaning a lot ... for some region the upload comes and for some region, it appears.. I need to figure it out from snowflake documentation

[@TheJayabright]

Is Snowflake is case sensitive?

[@DataEngineering]

In general NO.. if you don't put object name during DDL, then everything is stored as upper case for example create or replace table my_db.my_schema."jaya T" Above statement will create a case sensitive table called java T with space between it On other hand.. create or replace table my_db.my_schema.jayaT This will create a table with name JAYAT Hope this helps..

[@fadiabusafat5162]

Bro, I like all your tutorials so far and it is amazing and I recommended everyone to watch it but kindly, would it is possible to have a copy of these slides ? I am looking to make Snowflake certificates and I need a copy for these slides for your all Snowflake. Is this possible. Many Thanks.

[@srinivastechnical]

sessions are very useful and thank you providing series of the sessions your going very fast please go slowly people will understand

[@DataEngineering]

Thanks, I will try my best.. the later part of the videos are slow...

[@namitamohanty4603]

Hey bro, can we get an entry level job in data engineering by just learning snowflake?

[@sowmyar632]

Bless you Sir :)

[@DataEngineering]

thank you... If you want to manage snowflake more programatically.. you can watch my paid contents .. many folks don't know the power of snowpark... this 2 videos... will help you to broaden your knowledge.. Thse 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/

[@paknadeemful]

good explanation

[@DataEngineering]

Keep watching

[@austinchettiar6784]

UI for snowflake has changed a lot lately:(

[@DataEngineering]

Yes ..right..this video was published long back.. and there are snowflake instances that are still having old web ui (so called legacy)... and since it is a cloud based platform, it is constantly adding features.

[@sayeefmohammad9754]

Hello Sir , How can I access Legacy Web UI as I am not getting this page when I login on Snowflake account ?

[@DataEngineering]

Legacy webui is no more available but you can go and check the profile page and see if it allows you to select legacy as your next login. But I doubt, if you can do it.. for some of the old account, legacy can still be access.. but if you are using new trial edition.. you will not get access to it..

[@srinathparuchuri6801]

Hi, Your way of teaching is very comfortable and understandable, If i want to reach you people, what is the way.

[@DataEngineering]

Glad you liked it You can drop a direct message via instagram (instagram.com/learn_dataengineering/)

[@sourabhpatel3834]

is classic ui no more available?

[@DataEngineering]

classic console is deprecated... so it is no more available for new signups.

[@dt0229]

awesome！

[@DataEngineering]

Glad you think so!

[@shantanumandal2930]

sir..where to find the source code and data set used in the videos?

[@DataEngineering]

I think, I forgot to upload the sql for some of the tutorial.. let me check and try to upload them.. thanks for your note

[@mayankgarga6878]

Thanks,Best

[@DataEngineering]

Thank you too!

[@satyaparvathi1355]

Sir what is meaning of clusters

[@DataEngineering]

in massive parallel processing computing approach, we use multiple computers (so called nodes, or slaves) and these computers, connected together is so called cluster.. ( sometime referred as master/slave in Hadoop/Bigdata world) I hope this clarifies..

[@BabarMohammed18]

How can we create account in roles

[@DataEngineering]

Wiat for my next video (episode 20) and I will explain everyting about role in snowflake. Thank you for watching and sharing your query. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ 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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

[@omenduelist9810]

But we can rename the worksheet

[@DataEngineering]

yes, you can

[@prabhatgupta6415]

Bring more different tech videos on DE

[@DataEngineering]

may be in future.. but now focus is only snowflake..

[@RK-wf7re]

Content is good, but voice quality seems low..

[@DataEngineering]

Thank you so much for your feedback @JK. Do you see same issue with my recent videos? Snowflake Access Control kzbin.info/www/bejne/pou0iX5tprRjn7s Snowflake ETL kzbin.info/www/bejne/b3fIm519i7-lhsk Do let me know if the audio quality is still poor in these videos or better. This helps a lot.

[@saivinith321]

Everything is good but voice is low bro

[@DataEngineering]

Thanks for you note.. have been improvising on it.. hope you would find the better voice in my latest and upcoming videos..

[@eloscarc5782]

Snowflake looks like MySQL Workbench

[@ankitkumar-kg5ue]

Entire ui of snowflake is now changed

[@DataEngineering]

Yes.. by Jan 2023, the classic WebUI will disappear.. and new account, they are making it hard to access classic WebUI.

[@BabluSharma-vd8cz]

Which companies have demands for snowflake in india ?

[@DataEngineering]

Many large companies are moving towards snowflake. You have to do a bit of research at your end.

[@Mehatajk]

Hello Dear Tutor, I have some doubts can you provide me your email so that I can reach out to you.

[@DataEngineering]

🚀🚀 How To Connect ✏ Instagram: instagram.com/learn_dataengineering/ ✏ Exclusive Snowflake Facebook Group: facebook.com/groups/627874916138090/