Week 42 – Intermediate

With the recent release of Individual Task Observability, we’re celebrating with a Task focussed challenge!

This new feature provides a level of visibility and insight into individual tasks that were previously unavailable and presents both opportunities and potential obstacles for those seeking to optimize their workflow. As people begin to explore the benefits and limitations of Individual Task Observability, they will need to navigate this new terrain with care and creativity, in order to maximize their productivity and achieve their goals. In this context, it is worth exploring the implications of this new feature, and considering strategies for using it effectively in various contexts and settings.

What we want you to create is built as a puzzle, meant to give you some constraints.

Create tasks representing 3 kids : Joan, Maggy and Jason.
Joan gets out of bed every 3 minutes and stays up for 2 minute
Maggy gets out of bed every 5 minutes and stays up for 1 minute
Jason gets out of bed every 13 minutes and stays up for 1 minute

Create a table called kids_out_of_bed with a column for :
– Time
– Joan
– Maggy
– Jason

The default is that all the kids columns should be FALSE

Create a Task structure to keep track of when kids get out of bed. For the minutes that a kid is out of bed , change the minute value to TRUE.
The child task should keep running while the kids are awake
The important constraint here however that we’re not just using a calculation but actual timestamps!
Example : Joan starts at 01.00 , the task runs, and notes that on 01.03 01.04 , she was awake. So we’re changing those values to TRUE.

If dad_task notices that all the kids are out of bed (which he checks every second), he freaks out , gets mad and everything stops. Make sure to include this in your tasks!

What is your end time for this task tree? Let us know!

3 responses to “Week 42 – Intermediate”

  1. ChrisHastie avatar

    I had fun with this one, especially since I was coding it pretty rapidly in the brief window whilst my own daughter is sleeping! Poor thing has an ear infection so sleep isn’t coming easy tonight.

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

    Some jinja fun for this one. And remember to clean up those tasks afterwards. Then double check you actually cleaned up everything. Oops.

    • Solution URL – https://github.com/dsmdavid/frostyfridays-sf/blob/main/models/challenge_42.sql
  3. Chris B avatar
    Chris B

    Not sure it was done exactly how intended, but it worked and stopped at minute 130 after kicking off all 4 tasks.
    Can’t get the dad task to run every second, as the min is 1 minute and it doesn’t insert a row for every single minute either.

    • Solution URL – https://github.com/ChrisBo94/FrostyFriday/blob/main/Week_42.sql

Leave a Reply