In this note, I am going to create my first Database and table in Snowflake, and load csv data files from AWS S3 into our table.
- Prepare your files
- Stage the data
- Execute COPY command
- Managing regular loads
So first of all, we need to create our database. Here we are creating a new database called
OUR_FIRST_DATABASE and our table called
-- Step 0: create database OUR_FIRST_DATABASE
Now we need to load the CSV file from AWS S3 into our table
OUR_FIRST_TABLE, here we can use the command
COPY INTO to achieve that:
-- Step 2: load data into table
After the data loading processing is completed, we need to validate our data is correct or not.
-- Step 3: validate result