Crystal clear, you did a good job in explaining things.
@atlanticoceanvoyagebird26302 ай бұрын
YOU ARE GREAT TEACHER IN EXPLAINING BEAUTIFUL WAY OF ENGLISH LANGUAGE PROUNICATIONS (not like others only confusions to understand English language pronunciations) AND SYSTEMTICALLY EASY WAY OF PRESENTING THAT HELPS ME TO LEARN AND TESTED SIMALTANEOUSLY. I CAN HOPE FOR SOMETHING IN THIS FIELD TO BE UNDERTAKEN. I LOVE YOUR WAY OF TEACHING METHODS THAT HELPS ME FOR THE NON-TECHNICAL BACKGROUND LIKE ME. MUHAMMAD from North America.
@KSRDatavizon2 ай бұрын
Thank you! 😃
@_chandrakant10 ай бұрын
The way you explain this concept is amazing. Thanks for content.
@KSRDatavizon9 ай бұрын
You are most welcome, Please subscribe our channel, it motivates a lot
@rajivgandhik84227 ай бұрын
What a enthusiastic explanation . Excellent bro!!!
@KSRDatavizon5 ай бұрын
Thank you so much for your kind words!
@shubhamalsunde32308 ай бұрын
the way you explain wow!!!!!
@KSRDatavizon8 ай бұрын
Thank you so much, Please subscribe our channel for regular updates ....
@sketchstudios054 ай бұрын
Thanks for this video, you explained in a very nice manner and its working.
@KSRDatavizon4 ай бұрын
Thank you for your kind words, they mean a lot to me!
@nisha2013 Жыл бұрын
Good one..had a clear view of data loading from AWS .. Thank you.. pls give more videos about snowflake DB...
@KSRDatavizon Жыл бұрын
Thank You Nisha; Sure As soon as possible we will come up with more Videos.
@anuragshrivastava7855 Жыл бұрын
it helped a lot, can you please make a video for continuous data upload in snowflake
@KSRDatavizon Жыл бұрын
sure sir, please subscribe our channel for regular updates
@muralik4198 Жыл бұрын
nice explanation. keep on doing videos on snowflake
@KSRDatavizon Жыл бұрын
Thank you, I will, please subscribe our channel for regular updates
@Mamtashekhawat-hu2ssАй бұрын
Amazing✌
@KSRDatavizonАй бұрын
Thanks ✌️
@pankajkishore22573 ай бұрын
Awesome explanation 🎉🎉❤❤
@KSRDatavizon3 ай бұрын
Thank you so much! I'm glad you found the explanation helpful.
@MuruOfficial9 ай бұрын
How to upload multiple csv files from single s3 bucket ? How to make it as a continues load without manual intervention ?
@sunandamarthala639 ай бұрын
Using snowpipe
@KSRDatavizon9 ай бұрын
you have use Snowpipe
@KSRDatavizon9 ай бұрын
Thank you
@crazy_MoviesBy0078 күн бұрын
Great ..but little need much practice...
@KSRDatavizon5 күн бұрын
I will try my best, Thank you for your suggestions .
@nomadduggsaАй бұрын
awesome
@KSRDatavizonАй бұрын
Thank you
@sandhireddysanath918910 ай бұрын
Good explanation
@KSRDatavizon5 ай бұрын
Thank you so much for your comment, Please like, share and subscribe our channel for regular updates. it motivates us a lot
@shivaaymalik3 ай бұрын
Good Explanation
@madhusudhanchinnala198611 ай бұрын
Thank you sir clear explanation
@KSRDatavizon11 ай бұрын
You are welcome
@yadalapoornasaichandra94165 ай бұрын
Nice explanation
@KSRDatavizon5 ай бұрын
Thanks for checking out the video and leaving a comment!, Please subscribe our channel for regular updates and it motivates us a lot... thanks again.
@rupalidhotre6204 Жыл бұрын
thanks for video it really helped
@KSRDatavizon Жыл бұрын
Glad it helped Thank you, Please subscribe our channel for regular updates, its motivate us
@user-rk8cj8qm7i Жыл бұрын
Thanks for making this vedio,it is providing good knowledge.please make more vedios.
@KSRDatavizon Жыл бұрын
You're welcome, please subscribe our channel for regular updates
@yamunau.yamuna5189 Жыл бұрын
Clear explination, bro can you please tell what are the prevalidations we do while loading from aws to snowflake table
@KSRDatavizon Жыл бұрын
Thank you, Please subscribe our channel for regular updates , all the best
@akshaykulkarni3240 Жыл бұрын
Thank you so much for this video
@KSRDatavizon Жыл бұрын
Most welcome 😊, Please subscribe our channle for regular updates
@insane20939 ай бұрын
How to use one stage to several schema under one database ? Pls ans my question if any query for this provide
@SidharthanPV Жыл бұрын
I heard that now Snowflake is available in AWS as a service. In that case all these stages and public access blocking is required? Please let me know.
@KSRDatavizon Жыл бұрын
Though snowflake is available.. It has some limitations.. Aws and snowflake is updating
@gowthambaski82172 ай бұрын
Hi nizamuddin i think you
@mohammedvahid5099 Жыл бұрын
I had practiced just with my S3 credentials it's making me error sir it told me that Unexpected 'STORAGE_AWS_ROLE_ARN'.(line 6)
@mohammedvahid509910 ай бұрын
Yes
@mohantejamuppalla69157 ай бұрын
If i have a file size of 5GB , how long it will take to load data into snowflake from S3
@KSRDatavizon5 ай бұрын
If i have a file size of 5GB , how long it will take to load data into snowflake from S3 Show drafts It's difficult to predict the exact time it will take to load a 5GB file from S3 to Snowflake due to several factors: Network bandwidth: The speed of your internet connection will significantly impact the transfer time. Higher bandwidth allows for faster data transfer. Snowflake credits: The amount of Snowflake credits you allocate to the COPY INTO command affects processing speed. More credits allow for parallel processing and faster loading. File format: Compressed formats like Parquet or Avro can load faster than uncompressed formats like CSV due to less data to transfer. Snowflake stage configuration: The configuration of your Snowflake stage can impact performance. Factors include the number of compute resources allocated and the type of storage used (e.g., internal vs. external). However, here are some resources that can help you estimate the loading time: Snowflake documentation: The Snowflake documentation provides information on COPY INTO: docs.snowflake.com/en/sql-reference/sql/copy-into-location.html and best practices for loading data. Snowflake sizing calculator: This tool (available through your Snowflake account) can help you estimate the resources needed for your workload, potentially impacting load times. Testing: The best way to determine the actual load time for your specific scenario is to perform a test load. You can upload a smaller sample file (e.g., 100MB) from S3 to Snowflake and measure the time it takes. This will give you a more accurate estimate for the 5GB file based on your environment. Here are some additional tips for potentially improving load times: Use efficient file formats: Consider using compressed formats like Parquet or Avro for faster transfer and processing. Optimize your stage: Ensure your Snowflake stage is configured with appropriate compute resources and storage type. Parallelize the load: Use the FILE_FORMAT option with SINGLE = FALSE in the COPY INTO command to allow Snowflake to split the file and load data in parallel, potentially improving speed. By considering these factors and potentially running a test load, you can get a better idea of how long it will take to load your 5GB file from S3 to Snowflake