Snowflake - External Stages - Working Session

[@devinanda4136]

Amazing explanation.Thanks

[@mayanknema3007]

It woule be really great if you can make one more videos on Stored Procedure & Views. With your style of teaching, this would help many to understand the concept of snowflake in easier way.

[@mrjana520]

Views video is already available, will upload stored procedures and UDFs very soon..

[@mayanknema3007]

@@mrjana520 ..Wooorr great. Waiting to get some crucial lessons on stored procedures. Just one request - Please use SQL language to create stored procedure instead of Javascript. So that we can align from our SQL knowledge also

[@DHswathi]

Brother pls tell me what is the schema....

[@yamunau.yamuna5189]

Really all my doubts of stages have cleared with this video thank you so much bro, your videos are very helpful who are searching for job in snowflake technology

[@amani8893]

Thankyou .. it is very informative

[@devinanda4136]

Hi Janardhan, while loading from external file from other source or sample s3 data like we are doing now, how will we know beforehand about column details or field delimeter etc?

[@mrjana520]

We have to get from file in s3, there is no option in snowflake

[@mrjana520]

docs.snowflake.com/en/user-guide/querying-metadata

[@seemanews]

How to create runtime landing tables / stages depending upon header columns and data in csv from s3

[@mrjana520]

We can write a python script or use some ETL tool, there is no direct way in Snowflake

[@pratikthole2414]

In Last example we did not mention any FIE_DELIMETER as , then how data loaded successfully ??

[@mrjana520]

Default field delimeter is , no need to mention if your files are comma separated

[@rajashekar4882]

Number of columns in file (1) does not match that of the corresponding table (6), use file format option error_on_column_count_mismatch=false to ignore this error

[@ShobhaPoojariM]

It's helped me a lot.

[@ThirumaleshNiraganti]

Hi, I tried checking the publicly accessing s3 bucket named as bucketsnowflakes3 in aws s3 bucket but didn't find it also tried directory bucket tab. pls help on this so that it will help us to use all those free files for practice.

[@mrjana520]

I am able to access the public S3

[@DHswathi]

Sir don't mind pls tell me what is cluster and schema .... I want word meaning clearly

[@mrjana520]

Schema contains tables, views and other database objects and relationships among those tables. Watch my video Micropartitioning and Clustering to know more about cluster...

[@UPavan07]

sir here we dont know what rows are there in Orders table (In stage object) but we simply created a table with headers that we dont know even exists in Orders file what happens if the headers mismatch or Can we access the files in stage object even before creating the tables

[@mrjana520]

In general or in real time, you will have access to external locations like s3 buckets, Azure blob, so you can see the file structures, need not to worry

[@karth2882]

​@@mrjana520, what if there are 50 columns, how to create table of those many columns in snowflake?

[@SaiKumarGaddam-g3x]

how to view the tables present in the s3 bucket without loading the data into snowflake How exactly we can know the column present in the tables to create in snowflake

[@mrjana520]

You can't view the file content from Snowflake. In real-time you will have access to your cloud and you can see the file content from cloud itself, need not to worry.

[@shaikjakeer1347]

Sir which snowflake your using while we install snowflake account we are not able to see this formate

[@mrjana520]

Enterprise edition hosted on aws cloud

[@mysteriovvn]

Excellent way of teaching. If possible can you share the excel shown for Snowflake objects parameters?

[@mrjana520]

Reach me on [e-mail]

[@epuriraghavendra3847]

What happens if we specify both files and pattern in COPY command

[@mrjana520]

It will consider the files you have mentioned, but just think why one will mention both in real-time

[@manideepsrirangam]

How do we move data from Snowflake to External Stage (S3). Is there any other process for that? Also, can we schedule this data transfers? One last question, what will be the cost from snowflake side? Will it be computation, data transfer or anything else?

[@mrjana520]

There is a one video in my channel with name: Unloading data, there I have explained how to unload data from Snowflake to AWS S3. For scheduling you can watch my Tasks video.

[@mrjana520]

You can get all videos, PPTs, queries and files in my Udemy course. 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=F1C5F3C67C25DFC40841 Use below coupon to get 100 rupees discount on my course. Coupon: F1C5F3C67C25DFC40841

[@Jas-ib8dh]

Hi, How to load table from Azure ADW to snowflake using ADF

[@mrjana520]

Sorry, i am not sure what is Azure adw, but we can load data from any other database to snowflake by using snowflake connector available in ADF. www.snowflake.com/blog/snowflake-connector-for-azure-data-factory-adf/

[@venkatakrishna9333]

hi sir where to download these type of files in internet through practice purpose

[@mrjana520]

I can be reachable on [e-mail]

[@upendravemula7901]

Sir... how do we differentiate Named Stage and External Stage?

[@mrjana520]

If you watch both videos External stages and Internal stages, you will get the answer for this question