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!
Another week, another fun challenge. Thanks
Thanks for the challenge, I don’t think I use the python worksheets too often 🙂
Very cool! Loving Snowpark so far
Thanks for the challenge 🙂