Zach Renwick
@zachrenwick.work
Data analytics engineer #SQL #DataModeling #Analytics #BigQuery #WebAnalytics
zachrenwick.work
zachrenwick.work
I agree but they've also been positioning Looker/BigQuery as a more open data stack recently. Specifically trying to market Looker modeler (the semantic layer part of Looker) as its own stand alone tool
February 11, 2025 at 7:36 PM
I agree but they've also been positioning Looker/BigQuery as a more open data stack recently. Specifically trying to market Looker modeler (the semantic layer part of Looker) as its own stand alone tool
BigQuery just released UNION ALL BY NAME
It solves the issue of perfectly aligning each field properly in SQL. As long as the fields have the same name you're good!
It solves the issue of perfectly aligning each field properly in SQL. As long as the fields have the same name you're good!
February 7, 2025 at 3:55 AM
BigQuery just released UNION ALL BY NAME
It solves the issue of perfectly aligning each field properly in SQL. As long as the fields have the same name you're good!
It solves the issue of perfectly aligning each field properly in SQL. As long as the fields have the same name you're good!
andddd that fixed our paid session count bug:
December 30, 2024 at 10:41 PM
andddd that fixed our paid session count bug:
Google Analytics 4 contains a known traffic source misattribution bug in the raw BigQuery export.
I fixed it with a few lines of code:
I fixed it with a few lines of code:
December 30, 2024 at 10:41 PM
Google Analytics 4 contains a known traffic source misattribution bug in the raw BigQuery export.
I fixed it with a few lines of code:
I fixed it with a few lines of code:
New [mountain] bike day! This thing is a beast, looking forward to the bigger brakes and suspension for north shore riding
December 23, 2024 at 1:54 AM
New [mountain] bike day! This thing is a beast, looking forward to the bigger brakes and suspension for north shore riding
Soemthing fundamentally wrong with Strava’s year in sport (Spotify wrapped, but for logging your exercise) is that December isn’t done yet and they’ve sent it out.
December 12, 2024 at 4:14 PM
Soemthing fundamentally wrong with Strava’s year in sport (Spotify wrapped, but for logging your exercise) is that December isn’t done yet and they’ve sent it out.
One of the first things I like to do with new hires is show them our global asset lineage in Dagster (the master DAG). It looks something like this
November 1, 2024 at 7:52 AM
One of the first things I like to do with new hires is show them our global asset lineage in Dagster (the master DAG). It looks something like this