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:
Starting Code Here
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!
5 responses to “Week 50 – Beginner”
-
Another week, another fun challenge. Thanks
- Solution URL – https://github.com/ChrisHastieIW/Frosty-Friday
-
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
-
Very cool! Loving Snowpark so far
- Solution URL – https://github.com/canonicalized/FrostyFriday/blob/main/WEEK50.py
-
Thanks for the challenge 🙂
- Solution URL – https://github.com/micolbedarida/Frosty_Friday/tree/main/Week50
-
1) SQL
2) Python- Solution URL – https://github.com/GerganaAK/FrostyFridays/blob/main/Week%2050%20%E2%80%93%20Basic
Leave a Reply
You must be logged in to post a comment.