Miles
@corndog.bsky.social
I care about my cats, music, and movies. Frequent data & analytics posting. he/him
Drinking at the bar watching the world series and my ass is writing SQL off of imaginary tables
October 31, 2025 at 12:34 AM
Drinking at the bar watching the world series and my ass is writing SQL off of imaginary tables
SELECT artist_name, monthly listeners
FROM playlist_songs left join playlist on playlist_songs.playlist_id = playlist.playlist_id
left join songs on playlist_songs.songid= songs.songid
left join artist on song.primary_artist_id = artist.artist_id
Where playlist_owner = me
Order 2 ASC
limit 1
FROM playlist_songs left join playlist on playlist_songs.playlist_id = playlist.playlist_id
left join songs on playlist_songs.songid= songs.songid
left join artist on song.primary_artist_id = artist.artist_id
Where playlist_owner = me
Order 2 ASC
limit 1
October 31, 2025 at 12:31 AM
SELECT artist_name, monthly listeners
FROM playlist_songs left join playlist on playlist_songs.playlist_id = playlist.playlist_id
left join songs on playlist_songs.songid= songs.songid
left join artist on song.primary_artist_id = artist.artist_id
Where playlist_owner = me
Order 2 ASC
limit 1
FROM playlist_songs left join playlist on playlist_songs.playlist_id = playlist.playlist_id
left join songs on playlist_songs.songid= songs.songid
left join artist on song.primary_artist_id = artist.artist_id
Where playlist_owner = me
Order 2 ASC
limit 1
My personal experience is that Parquet loads much faster than csv into BQ
October 30, 2025 at 6:12 PM
My personal experience is that Parquet loads much faster than csv into BQ
Likewise! Really enjoyed your talk on Analytics Program Evals!
October 5, 2025 at 8:20 PM
Likewise! Really enjoyed your talk on Analytics Program Evals!
Nevermind this is going totally fine
October 4, 2025 at 6:51 PM
Nevermind this is going totally fine