How to Load Data from S3 to Snowflake

An example of how to load data from S3 to Snowflake

Image on Unsplash

Join Medium with my referral link - George Pipis

Create a Database

The first thing that we need to do is to create a database. This is easy. We login into the Snowflake platform and we go to Databases.

Then we click on Create. For this tutorial the database will be the GPIPIS_DB

In the database, we can create a schema, where the default is the “public” and we can create a table or a schema by clicking on the Create button.

Let’s say that I want to create the MYIRISTABLE. In this tutorial, we will create the tables and the stages programmatically.

Create a Warehouse

Similarly, we can create the warehouse by clicking on Warehouses and then on the Create button.