Snowflake data loading from internal stages (User | Table | Named) || Complete practical session

[@askycoding]

For Scripts and files used in the video, checkout my github account : github.com/shivam-sky/Snowflake_Full_Course_tutorial

[@rohitbhagwat3031]

Thank you for the video.👍

[@rajrajabhathor2996]

Awesome Shubham !!

[@StockGarjanaHindi]

Timestamp '43:20.8' is not recognized while copying into into table . what to do?

[@kailashsathia3080]

have the column contaning timestamps as nvarchar. then convert the data in the select statement of snowflake

[@reportevents5650]

Bro date birth can't able to load 😢invalid like that after removing only I am able to do can you provide some tips to load date

[@ArunNeerudu]

same doubt

[@kalyanik4577]

If source file structure detail not share and its pretty huge size how to load it into table and flatten it out .[Not autocompression='false' or parallel hint not allowed ]

[@ranganatho707]

Hello Sir, I have downloaded the csv file( excel:comma separated file) from internet, tried to load it into the internal stage by using put command but got an error which is says file does not exist, tried to fix it up but failed many times, file is available in the path of put command, I am failed to understand the behavior of snowsql and worksheet of snowflake!! Thanks in advance for your help!!

[@askycoding]

bro come on Instagram, send me the screenshot of your file and error. I'll help you out there.

[@askycoding]

Send your query which you r using for uploading file to internal stage....

[@footballfanatic4437]

bro, for working with internal stages do we always have to connect with command line SQL ?

[@askycoding]

yes because put command will not work in web ui or snowsight.

[@sanishthomas2858]

Very nice.. quick question, if I put file from local to User or Table Stage using SnowSQL and then can I automatically load my data from TableStage or user Stage into the main table using Pipe? I tried but it is not working. pls confirm

[@askycoding]

No, you cannot directly load files from user or table stages into Snowflake tables using Snowpipe. Snowpipe is specifically designed to load files from external stages. It cannot directly access files within internal stages like user or table stages instead you can try with copy commans.

[@sanishthomas2858]

Then what is next way to automate the loading of data from internal stage to permanent tables

[@ur8946]

what is use of parallel in put command ?

[@askycoding]

It'll help with performance when uploading large data files.

[@askycoding]

if u r using parallel property then large data files will get uploaded to internal stages in less time in comparison with without parallel

[@VChandraKumarReddy]

u have not created stage right so how u can move excel file here ?

[@R....1]

can you please give me the customer_1.csv please give me file link this file is not in github i alredy share this video to my 4 friend please give me the file link

[@mayursuryawanshi2872]

253006 (n/a): File doesn't exist: ????

[@askycoding]

Double-check the stage name and ensure that it exists in your Snowflake account. Also, ensure that you have the necessary permissions to access the stage and checkout for the file is present at same location or not

[@EskGaming]

Ok ok ok ok