Frosty Friday

Snowflake Weekly Challenges

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

by on 57 Comments

Week 1 – Basic

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:

  1. 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)
  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.

If you have any technical questions you’d like to pose to the community, you can ask here on our dedicated thread.

57 responses to “Week 1 – Basic”

  1. haythembsd avatar
    haythembsd

    let’s get started

    • Solution URL – https://github.com/HaythemBsd/hbsd_frosty_friday/tree/main
  2. javii avatar
    javii

    Load data from an external stage using List_AGG window function . Thank you!!

    • Solution URL – https://github.com/JavaCaste/snow/blob/main/Week1_Basic_ExternalStages.sql
  3. tshoji avatar
    tshoji

    Let’s get started!

    • Solution URL – https://github.com/taksho/Frosty_Friday/blob/main/Week1/external_stages.sql
  4. dzapp avatar
    dzapp

    🙂

    • Solution URL – https://github.com/darylkit/Frosty_Friday/blob/main/Week%201%20-%20External%20Stages/external_stages.sql
  5. tomo avatar
    tomo

    I mixed various other people’s codes and added Japanese translations.
    I have included the GitHub URLs of the people I cited in the code.

    • Solution URL – https://github.com/tomoWakamatsu/FrostyFriday/blob/main/FrostyFriday-Week1.sql
  6. gaku_t avatar
    gaku_t

    Start Frosty-Friday in Japan Snowflake Community !

    • Solution URL – https://github.com/gakut12/Frosty-Friday/blob/main/week1_basic_external_stages/week1.sql
  7. allllllllez avatar
    allllllllez

    let’s get started!

    • Solution URL – https://github.com/allllllllez/frosty_friday/blob/main/sql/week-1.sql
  8. marcopastore avatar
    marcopastore

    This was funny!

    • Solution URL – https://github.com/marco-pastore-HH/Frosty-Friday-Challenges/tree/main
  9. marcoscatassi avatar
    marcoscatassi

    Let’s kick off!

    • Solution URL – https://github.com/marco-scatassi-nimbus/Frosty-Friday/blob/main/week1/read_csv_from_s3_bucket.sql
  10. gergana98 avatar
    gergana98

    This is my version of the solution for this task. I hope you find it helpful! ^^

    • Solution URL – https://github.com/GerganaAK/FrostyFridays/blob/main/Week%201%20%E2%80%93%20Basic
  11. behnazhd avatar
    behnazhd

    let’s get started 🙂

    • Solution URL – https://github.com/BehnazHeidaridehoee/frostyfriday/blob/main/week1/frosty_friday_week1
Older Comments
1 2 3

Leave a Reply

Reader Interactions

Comments

  2. Load data from an external stage using List_AGG window function . Thank you!!

    • Solution URL - https://github.com/JavaCaste/snow/blob/main/Week1_Basic_ExternalStages.sql

  4. 🙂

    • Solution URL - https://github.com/darylkit/Frosty_Friday/blob/main/Week%201%20-%20External%20Stages/external_stages.sql

  5. I mixed various other people’s codes and added Japanese translations.
    I have included the GitHub URLs of the people I cited in the code.

    • Solution URL - https://github.com/tomoWakamatsu/FrostyFriday/blob/main/FrostyFriday-Week1.sql

  6. Start Frosty-Friday in Japan Snowflake Community !

    • Solution URL - https://github.com/gakut12/Frosty-Friday/blob/main/week1_basic_external_stages/week1.sql

  9. Let’s kick off!

    • Solution URL - https://github.com/marco-scatassi-nimbus/Frosty-Friday/blob/main/week1/read_csv_from_s3_bucket.sql

  10. This is my version of the solution for this task. I hope you find it helpful! ^^

    • Solution URL - https://github.com/GerganaAK/FrostyFridays/blob/main/Week%201%20%E2%80%93%20Basic

  11. let’s get started 🙂

    • Solution URL - https://github.com/BehnazHeidaridehoee/frostyfriday/blob/main/week1/frosty_friday_week1

Leave a Reply