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.
25 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
Leave a Reply
You must be logged in to post a comment.