Frosty Friday

Snowflake Weekly Challenges

You are here: Home / Uncategorized / Week 23 – Basic

by on 8 Comments

Week 23 – Basic

This week we’re looking into another feature that most starters haven’t touched before :
SnowSQL

“SnowSQL is the command line client for connecting to Snowflake to execute SQL queries and perform all DDL and DML operations, including loading data into and unloading data out of database tables.” (https://docs.snowflake.com/en/user-guide/snowsql.html)

This week, we’re going to ask you to use it for one of the features that it’s best known for however: the Bulk loading feature.

You’ve been asked to upload some files into a table and the Sales Manager said that “it’ll only take you about 2 minutes”.
So we’re pretty clear that it’ll take us at least 15 .

The challenge :

  • Download the zip file containing the CSV files here
  • Download and install SnowSQL on your machine from this page
  • Connect to your Snowflake instance with SnowSQL
  • Bulk load the files ending with a ‘1’ (data_batch_1-1.csv, data_batch_1-11.csv etc.)
  • skip any erroneous file

The desired result should look like this :

Remember, if you want to participate:

  1. Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘
  2. Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
  3. Post the URL in the comments of the challenge

Reader Interactions

Comments

  1. Another fun challenge to finish off the week, thanks!

    • Solution URL - https://github.com/ChrisHastieIW/Frosty-Friday

  2. Today was the first snow of the season – let it snow 🙂

    • Solution URL - https://github.com/mateusz-kmon/frostyfridaychallenges/blob/main/w23.sql

  4. Easy one, but I hardly ever use SnowSQL, so it was a nice refresher!

    • Solution URL - https://github.com/mferle/FrostyFriday/blob/6d29ab8cfb4f2fd3cfcf94c3f60174635bb7018c/Week%2023%20%E2%80%93%20Basic/Week23_solution.sql

  6. nice!

    • Solution URL - https://github.com/lbinfolab/frosty-friday/blob/22c2a03f110bfe8b8e2231903f9466f82593862b/week23.sql

  7. First Frosty Friday challenge. I removed trial and error parts from the code.

    • Solution URL - https://github.com/darko-nimbus/frostyfriday_challenges/commit/a880cc90f41b1ada4aeedaee25332248ae45bffe

  8. Learning a bit on the cmd window, never used it before.

    • Solution URL - https://github.com/zlzlzl2-data/FrostyFriday/blob/main/FF023_LZ.sql

Leave a Reply