Create a table in snowflake using external data Recently I needed to upload a data into snowflake as a table and perform some operations on it. Surprisingly as it is, I found that although I knew how to create a table in sql; I didn't know how to upload a data into snowflake. Obviously, I could have gone into internet to find out python libraries to solve this problem; i.e. access snowflake via a python session, then get the data and upload it in some probable template for tables. But it was a quick work and I wanted to do it fast. So I chose to upload it in a s3 data bucket and then create an empty table in snowflake; in which I would then put the data, pulling it into snowflake from s3. Now that is a nice and easy way to do; and let's see the exact procedure and how do we complete each of the parts. Upload the data into s3: Uploading data into s3 can be done again in two ways. The first one is to use a boto3 session and then upload the data into s3 via that boto session. If
I write about machine learning models, python programming, web scraping, statistical tests and other coding or data science related things I find interesting. Read, learn and grow with me!