Snowflake External Tables - Working Session - Queries in the Description

[@vamsireddy5051]

@janardhan sir, your lectures make us easy to understand the concepts, Thanks lot sir🤝🏆

[@Rajkumar-tg3my]

wonderful series on snowflake.. U are unique for this topic keep rocking sir

[@mrjana520]

Thanks a ton

[@anudavuluri835]

All of your videos are simply superb n very understandable...if possible can you please keep the videos on Streams and cloning concepts. Pleaseeee..

[@mrjana520]

Cloning - th-cam.com/video/EMEAhuBFXlk/w-d-xo.html

[@1112electronics]

Great video..thanks

[@balakrisna4207]

Superb bro Inka latest topics (store procedure or task snowpipe ) Chepandi anna

[@shaikjakeer1347]

Nice explananation sir

[@shaikjakeer1347]

Need number sir

[@mrjana520]

I can be reachable on [e-mail]

[@jenniferdeguzman5736]

Hello can you also please share the one drive link for me? Appreciate all your tutorials! 🎉

[@mrjana520]

That drive link is not active anymore.
You can get all snowflake videos, PPTs, queries, interview questions and practice files in my Udemy course for very less price.. I will be updating this content and will be uploading all new videos in this course.
My Snowflake Udemy Course:
www.udemy.com/course/snowflake-complete-course-for-clearing-interviews/?couponCode=0D096876AA7A5A91FBCD
Use the coupon below to get a discount on my course.
Coupon: 0D096876AA7A5A91FBCD

[@Ajjeshh]

can we create transient or permanent tables against external tables?

[@mrjana520]

what ever external tables you create over the files present in external stages are permanent only

[@sarithakakarla-y1x]

Hi Sir, can you please explain exactly how to work streams on external table.

[@mrjana520]

It works same as streams on normal tables, watch my Streams video

[@m.s.krishnamurthykitta]

Any doubts about SNowflake come to this channel & clear all your doubts. #TQ guruji for everything

[@ravikumarranga1294]

Hello Janardhan, appreciate your efforts in making detailed videos. Do you have any other material or questions dump to take snowflake pro certification? Thanks

[@mrjana520]

Hi, I don't have dumps

[@AlDamara-x8j]

Thanks alot for this video. Is your udemy course recorded using the new interface? Is it currently possible to do advance data transformations on tables/dataframes on the new UI?

[@mrjana520]

Some of the videos were recorded in old classic interface, some of them were from new Snowsight. And answer for your 2nd question is Yes we can do

[@AlDamara-x8j]

@@mrjana520 Great. I really like your way of teaching. Thanks for the answer!

[@RakeshRanjan-hf4pr]

After creating external table, even If I delete all the files from s3. And when I run select command from external table, it still shows the records, how ?

[@mrjana520]

It will not fetch any data if you delete the files..

[@PriyankaPk-si6em]

hello sir How to load random data to snowflake.please explain me

[@mrjana520]

I don't understand the question, from where to load, what random means, can you please elaborate

[@PriyankaPk-si6em]

@@mrjana520 sir how to get datas for practice purpose. Instead of creating

[@PriyankaPk-si6em]

one drive link

[@mrjana520]

[e-mail]

[@RakeshRanjan-hf4pr]

Can we clone external table ?

[@mrjana520]

No

[@awsandme]

can you share one drive link for data

[@mrjana520]

Your mail id pls

[@pavanchowdary4793]

@@mrjana520 please share me the drive andi.. i

[@ArunNeerudu]

CAN U SHARE CSV FILES PLEASE