FrostyFriday Inc., your benevolent employer, has an S3 bucket that is filled with .csv data dumps. This data is needed for analysis. Your task is to create an external stage, and load the csv files directly from that stage into a table.
The S3 bucket’s URI is: s3://frostyfridaychallenges/challenge_1/
Remember if you want to participate:
- Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘ (note joining our mailing list does not give you a Frosty Friday account)
- Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
- Post the URL in the comments of the challenge.
If you have any technical questions you’d like to pose to the community, you can ask here on our dedicated thread.
52 responses to “Week 1 – Basic”
-
Started with this. Seems quite interesting!
- Solution URL – https://github.com/ankitsr92/Ankit_Work/blob/main/FrostyFriday/Week1/Week1.sql.txt
-
Off to a good start!
- Solution URL – https://github.com/alaishaa/frostyfridays/blob/main/Week1/Week1.sql
-
[…] ❄️ Challenge: Frosty Friday () | Week 1- Basic […]
-
Starting off the frosty challenges 🙂
Seems really helpful for learning Snowflake. Thank you!- Solution URL – https://github.com/anakomissaroff/Frosty_Friday/blob/main/Week1
-
W1 done! 🙂
- Solution URL – https://github.com/CSimonini/Frosty_Friday/blob/main/W1_Solution
-
Had fun.
- Solution URL – https://github.com/vdharst/Frosty_Fridays/blob/main/Week_1.sql
-
Nice foundational start to the challenges.
-
Solution URL updated
- Solution URL – https://github.com/jameskalfox/frosty-friday-snowflake-challenges/blob/main/Week_01.sql
-
My first challenge and still a lot to learn for me
-
Basic? lol
- Solution URL – https://github.com/liamholla/frosty_fridays/blob/main/challenge_1
-
New things learned:
– the metadata$filename and metadata$file_row_number columns are handy for storing the row order in the source files
– adding NULL_IF to the file format allows for cleanup of unneeded string values (in this case ‘NULL’ and ‘totally_empty’)- Solution URL – https://github.com/apd-jlaird/frosty-friday/blob/main/week_1/ff_week_1.sql
-
Done
- Solution URL – https://github.com/indigo13love/FrostyFriday/blob/main/week1.sql
-
Learned a lot! Reffered to a blog.
- Solution URL – https://github.com/rikafujiwara0/Frosty_Friday/blob/main/week1
-
Nice intro to some basic snowflake setup!
- Solution URL – https://github.com/BenAConnor/Frosty_Friday/blob/main/Week%201%20Solution.sql
-
First challenge. Love it so far!
- Solution URL – https://github.com/canonicalized/FrostyFriday/blob/main/WEEK1.sql
-
https://github.com/arjansnowflake/Frosty_Friday/blob/main/Week_1/week_1.sql
- Solution URL – My first Frosty Friday, yay!
-
Got it the other way around, yay!
- Solution URL – https://github.com/arjansnowflake/Frosty_Friday/blob/main/Week_1/week_1.sql
-
“you have gotten it right congratulations!”
https://github.com/marioveld/frosty_friday/tree/main/ffw1
- Solution URL – https://github.com/marioveld/frosty_friday/tree/main/ffw1
-
Hope this works!
- Solution URL – https://github.com/tlbakker/Frosty-Friday/blob/main/FF%20Week%201.sql
Leave a Reply
You must be logged in to post a comment.