Snowflake Trial

Week 50 – Beginner

This week, we’re dipping our toes into Snowpark. A feature that might feel a bit daunting to most of us, but that’s why we do these challenges!

This time, we’re looking into interacting with it in 2 ways, with a SQL query and Python itself.

The startup code for this exercise is pretty basic:

create table F_F_50 (
	id INT,
	first_name VARCHAR(50),
	last_name VARCHAR(50),
	email VARCHAR(50)
);
insert into F_F_50 (id, first_name, last_name, email) values (1, 'Arly', 'Lissaman', 'alissaman0@auda.org.au');
insert into F_F_50 (id, first_name, last_name, email) values (2, 'Cary', 'Baggalley', 'cbaggalley1@aol.com');
insert into F_F_50 (id, first_name, last_name, email) values (3, 'Kimbell', 'Bertrand', 'kbertrand2@twitpic.com');
insert into F_F_50 (id, first_name, last_name, email) values (4, 'Peria', 'Deery', 'pdeery3@addtoany.com');
insert into F_F_50 (id, first_name, last_name, email) values (5, 'Edmund', 'Caselli', 'ecaselli4@prweb.com');
insert into F_F_50 (id, first_name, last_name, email) values (6, 'Davin', 'Daysh', 'ddaysh5@liveinternet.ru');
insert into F_F_50 (id, first_name, last_name, email) values (7, 'Starla', 'Legging', 'slegging6@soundcloud.com');
insert into F_F_50 (id, first_name, last_name, email) values (8, 'Maud', 'Jaggers', 'mjaggers7@businesswire.com');
insert into F_F_50 (id, first_name, last_name, email) values (9, 'Barn', 'Campsall', 'bcampsall8@is.gd');
insert into F_F_50 (id, first_name, last_name, email) values (10, 'Marcelia', 'Yearn', 'myearn9@moonfruit.com');

The challenge for this week is :

  • Use a Python worksheet and a SQL query to return every row of data with the last_name = Deery
  • Use a Python worksheet and a Python snippet to return every row of data with the last_name = Deery

This time, we don’t have any tricks up our sleeves: It’s just to get our toes wet with a Beginner challenge!

4 responses to “Week 50 – Beginner”

  1. ChrisHastie avatar
    ChrisHastie

    Another week, another fun challenge. Thanks

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

    Thanks for the challenge, I don’t think I use the python worksheets too often 🙂

    • Solution URL – https://github.com/dsmdavid/frostyfridays-sf/blob/main/models/challenge_50_01.py
  3. canonicalized avatar
    canonicalized

    Very cool! Loving Snowpark so far

    • Solution URL – https://github.com/canonicalized/FrostyFriday/blob/main/WEEK50.py
  4. micolbedarida avatar
    micolbedarida

    Thanks for the challenge 🙂

    • Solution URL – https://github.com/micolbedarida/Frosty_Friday/tree/main/Week50

Leave a Reply