A feature that enables us to load and unload the data from snowflake’s existing tables into the snowflake stages.
You can use the snowflake copy command to load the data from the local system by internal stage or from the cloud storage like s3 by external stage.
If you are reading this article I assume that you are already aware of the Snowflake stage concept, Cloud storage S3, how to integrate cloud storage with snowflake, and Snowflake storage integration.
Check out my other articles to get some understanding of these topics.
Export Data From Snowflake To S3
Load CSV from Local to Snowflake
Based on the above articles create a storage integration in snowflake( In my case it is AYUSH_SI)
I have two file load1.csv and load2.csv that contains two columns NAME and MARKS.
Now upload the load1.csv file to the S3 bucket
(In my case it is s3://dev-ayush-test/test/) and create an external stage to…
