by A stakeholder in the HR department wants to do some change-tracking but is concerned that the stream which was created for them gives them too much info they don’t care about.
Load in the parquet data and transform it into a table, then create a stream that will only show us changes to the DEPT and JOB_TITLE columns.
You can find the parquet data here.
Execute the following commands:
UPDATE <table_name> SET COUNTRY = 'Japan' WHERE EMPLOYEE_ID = 8;
UPDATE <table_name> SET LAST_NAME = 'Forester' WHERE EMPLOYEE_ID = 22;
UPDATE <table_name> SET DEPT = 'Marketing' WHERE EMPLOYEE_ID = 25;
UPDATE <table_name> SET TITLE = 'Ms' WHERE EMPLOYEE_ID = 32;
UPDATE <table_name> SET JOB_TITLE = 'Senior Financial Analyst' WHERE EMPLOYEE_ID = 68;The result should look like this:
- 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)
- Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
- 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.
33 responses to “Week 2 – Intermediate”
-
I used an external stage and INFER_SCHEMA() for the Parquet file:
https://github.com/marioveld/frosty_friday/tree/main/ffw2
Fun challenge!
- Solution URL – https://github.com/marioveld/frosty_friday/tree/main/ffw2
-
curve ball with the column selection
- Solution URL – https://github.com/NMangera/frosty_friday/blob/main/wk%202%20-%20intermediate%20/streams
-
I used an internal stage and upload a file from UI, and infer_schema().
- Solution URL – https://github.com/taksho/Frosty_Friday/blob/main/Week2/stream.sql
-
🙂
- Solution URL – https://github.com/darylkit/Frosty_Friday/blob/main/Week%202%20-%20Streams/streams.sql
-
Used internal stage and infer_schema() (infer_schema was new to me)
- Solution URL – https://github.com/Nardeepm/Frosty_Friday/blob/main/Week%202%20Frosty%20Friday.sql
-
I use infer_schema(Schema Detection).It’s very useful!
My code Comments is in Japanese.- Solution URL – https://github.com/tomoWakamatsu/FrostyFriday/blob/main/FrostyFriday-Week2.sql
-
I’m translating the Japanese text of the Challenge.
The first solution involves using INFER_SCHEMA.
The second solution doesn’t utilize INFER_SCHEMA; instead, it relies on an older method, which proved to be quite challenging.- Solution URL – https://github.com/gakut12/Frosty-Friday/blob/main/week2_intermediate_streams/week2.sql
-
Loading the parquet file through snwosight was really satisfying. I wonder if there are alternatives to the usage of a view to accomplish the task???
- Solution URL – https://github.com/marco-scatassi-nimbus/Frosty-Friday/tree/main/week2
-
Import of data has been made through snowsql and using infer_schema() function but it could have been easily done using the Snowflake User Interface.
I solved the challenge but I don’t understand the fact that if I change again the “dept” column, updating “marketing” with another value, for example “finance”, the stream just tell me that the old value “accounting” has been removed.
Instead I was expeccting to see that the old “marketing” value as been removed.
- Solution URL – https://github.com/marco-pastore-HH/Frosty-Friday-Challenges/blob/main/ff_challenge_2.sql
-
Setup Internal stage,
load data from Parquet files into table From UI,
create view and stream,
perform updates, and query results 😉- Solution URL – https://github.com/BehnazHeidaridehoee/frostyfriday/blob/main/week2/frosty_friday_week2
Leave a Reply
You must be logged in to post a comment.