Frosty Friday

Snowflake Weekly Challenges

You are here: Home / Easy / Week 72 – Basic

by on 5 Comments

Week 72 – Basic

This week, we’re looking into a new Snowflake feature, EXECUTE IMMEDIATE FROM.

Take the following sql:

create table week72_employees (
    employeeid int,
    firstname string,
    lastname string,
    dateofbirth date,
    position string
);

Create an external stage to the following location:

s3://frostyfridaychallenges

Execute immediate from the command inside, and your data should look like:

Happy executing!

5 responses to “Week 72 – Basic”

  1. ChrisHastie avatar
    ChrisHastie

    A quick and fun challenge to wrap up the week, thanks for continuing to promote new functionality!

    • Solution URL – https://github.com/ChrisHastieIW/Frosty-Friday
  2. Norman M avatar
    Norman M

    learn something new every week

    • Solution URL – https://github.com/NMangera/frosty_friday/blob/main/week%2072%20-%20basic%20/EXECUTE%20IMMEDIATE
  3. dsmdavid avatar
    dsmdavid

    Thanks for the challenge! Intrigued about the possibility, also very scared of running it from an uncontrolled stage

    • Solution URL – https://github.com/dsmdavid/frostyfridays-sf/blob/main/models/challenge_72_01.sql
  4. mvdvelden avatar
    mvdvelden

    Liked this challenge. Because I was also nervous about just running the code , I decided to also add a few statements that enabled me to look at the code from within Snowflake:

    https://github.com/marioveld/frosty_friday/tree/main/ffw72

    • Solution URL – https://github.com/marioveld/frosty_friday/tree/main/ffw72
  5. darko avatar
    darko

    I trusted the FF admins on this one.

    • Solution URL – https://github.com/darko-nimbus/FROSTYFRIDAYCHALLENGES/blob/main/72%20-%20Basic%20-%20Execute%20Immediate/72%20-%20Basic%20-%20Execute%20Immediate.sql

Leave a Reply

Reader Interactions

Comments

  1. A quick and fun challenge to wrap up the week, thanks for continuing to promote new functionality!

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

  2. learn something new every week

    • Solution URL - https://github.com/NMangera/frosty_friday/blob/main/week%2072%20-%20basic%20/EXECUTE%20IMMEDIATE

  3. Thanks for the challenge! Intrigued about the possibility, also very scared of running it from an uncontrolled stage

    • Solution URL - https://github.com/dsmdavid/frostyfridays-sf/blob/main/models/challenge_72_01.sql

  5. I trusted the FF admins on this one.

    • Solution URL - https://github.com/darko-nimbus/FROSTYFRIDAYCHALLENGES/blob/main/72%20-%20Basic%20-%20Execute%20Immediate/72%20-%20Basic%20-%20Execute%20Immediate.sql

Leave a Reply