Erika Pullum (she/her)
LightNews LightNews
erikapullum.bsky.social
Erika Pullum (she/her)
@erikapullum.bsky.social
320 followers 220 following 42 posts
Engineer, climber, currently working as Head of Data at Hex.

www.erikapullum.com
Posts Replies Media Videos
erikapullum.bsky.social
Super #SQL brainteaser for your Tuesday that kept a few folks on our team thinking pretty hard until someone made an elegant solution.

The desired behavior per unit:
* First event qualifies
* Subsequent events qualify only if it's been more than 90 days since the last

Sample dates below #dataBS
A table of dates. 2024-06-10, 2024-09-17, and 2024-12-21 are labeled true. 2024-08-20, 2024-08-22, 2024-09-19, 2024-11-01, and 2024-12-11 are labeled false for is_after_cooldown
December 10, 2024 at 8:12 PM
erikapullum.bsky.social
aaaand it worked
A response from github user caitlinmoorman that says I.love.it.
December 9, 2024 at 10:40 PM
erikapullum.bsky.social
Continuing my theme of banger PRs -- this one improved documentation for a field confusing to a lot of folks

#dataBS
A PR title for #1607 that reads `Erika/delight caitlin`
December 9, 2024 at 10:35 PM
erikapullum.bsky.social
10x analytics engineer kinda Friday
A screenshot of a merged GitHub PR titled I Hate Everything About You with a branch name called erika/dependency-hell-suck-it
November 22, 2024 at 3:03 PM