iiinova — where your digital self keeps evolving

Zach Renwick

@zachrenwick.work

136 followers 148 following 51 posts

Data analytics engineer #SQL #DataModeling #Analytics #BigQuery #WebAnalytics zachrenwick.work

Posts Replies Media

Zach Renwick @zachrenwick.work · 11/02/2025

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

020

Zach Renwick @zachrenwick.work · 07/02/2025

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!

062

Zach Renwick @zachrenwick.work · 30/12/2024

andddd that fixed our paid session count bug:

000

Zach Renwick @zachrenwick.work · 30/12/2024

Google Analytics 4 contains a known traffic source misattribution bug in the raw BigQuery export. I fixed it with a few lines of code:

131

Zach Renwick @zachrenwick.work · 23/12/2024

New [mountain] bike day! This thing is a beast, looking forward to the bigger brakes and suspension for north shore riding

020

Zach Renwick @zachrenwick.work · 12/12/2024

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.

000

Zach Renwick @zachrenwick.work · 01/11/2024

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

000