Sign in

Zach Renwick

@zachrenwick.work
136 followers 148 following 51 posts

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

PostsRepliesMedia
Reposted by Zach Renwick
Dennis Detwiller @drgonzo123.bsky.social · 11/02/2025
366317066226
Zach Renwick @zachrenwick.work · 10/02/2025
Anyone here used Looker (as a semantic/metrics layer) and Tableau together? How is the native Looker to Tableau connector?
210
Zach Renwick @zachrenwick.work · 07/02/2025
Is there going to be a Small data meetup in Vancouver or Seattle this year? @duckdb.org @motherduck.com Please make it happen!
010
Zach Renwick @zachrenwick.work · 07/02/2025
Another analytics engineering (AE) LinkedIn bash post. Hard to not react (my current job) but having an AE title does not assume you will build a spaghetti data architecture. There are tons of data engineers who create perfectly optimized data models that are used by no one.
150
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 · 16/01/2025
Complex measure calculations in raw SQL is driving me insane. Yes we want to transform data in data warehouse/version controlled code, but these final mile calculations are so much easier/flexible to complete in a BI tool. Really missing Power BI right now lol
000
Zach Renwick @zachrenwick.work · 07/01/2025
I've never been to a data conference. In 2025 I'm making it happen (even if I have to personally pay for it, or if it's just a small data meetup in Seattle)
010
Zach Renwick @zachrenwick.work · 07/01/2025
Perpetually flip flopping on self serve analytics Some days it feels like it could be the holy grail - enabling downstream users to do their own exploration and analysis on governed metrics. Fewer ad hoc requests! Reporting automation! Other days: So what? Does that actually move the needle?
231
Zach Renwick @zachrenwick.work · 04/01/2025
Some of you have never had to fight for BigQuery slots and it shows
010
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 · 30/12/2024
Pretty easy to verify your bluesky account if you already have a domain. I just did mine using the below guide... does this mean I get a blue check now??? bsky.social/about/blog/4...
bsky.social
How to verify your Bluesky account - Bluesky
Here's how to verify your Bluesky account by setting your website as your username.
000
Zach Renwick @zachrenwick.work · 27/12/2024
It’s a damn tough market out there right now, particularly in Vancouver tech scene. You never know where you could end up, I nearly applied for some data jobs at this company before getting my current role dailyhive.com/canada/bench...
dailyhive.com
Canadian fintech startup Bench announces abrupt closure | National
Bench, North America's largest bookkeeping service for small businesses, has suddenly closed, leaving employees and clients scrambling.
120
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
Reposted by Zach Renwick
The Onion @theonion.com · 04/12/2024
Standing Desk Celebrates 4th Year At Lowest Possible Setting
Standing Desk Celebrates 4th Year At Lowest Possible Setting

-The Onion
9711218669
Reposted by Zach Renwick
archie.md @archie.sarrewood.com · 19/12/2024
@zachrenwick-data.bsky.social's resume is on @evidence.dev 🤯 zachrenwick.work
074
Zach Renwick @zachrenwick.work · 17/12/2024
Sorry, how much?!? techcrunch.com/2024/12/17/d...
techcrunch.com
Databricks raises $10B as it barrels toward an IPO | TechCrunch
Databricks, the data analytics platform, has raised $10 billion in a funding round that values the company at $62 billion.
000
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 · 11/12/2024
Am I right in thinking one of the major benefits of open table formats is being able to bring your own compute (even if it's local?) I'm envisioning a future where I can load my development BigQuery/Iceberg/Tabular tables using my local machine. Anyone doing this already?
320
Zach Renwick @zachrenwick.work · 28/11/2024
Sick of waiting for inconsistent Google Analytics 4 data to land in BigQuery? No problem, just turn on Fresh Daily export. Data has been ready by 3am every day! Oh yeah and one small detail, you have to pay >$50k for GA360 🤷‍♂️
010
Zach Renwick @zachrenwick.work · 26/11/2024
Crazy that I started my data career as a project accountant with PowerPivot in Excel and after 8 years I find myself going back to it for quick/scrappy analytics PowerPivot provides the model/relationships/metrics and I connect to BigQuery datasets with ODBC.
100
Zach Renwick @zachrenwick.work · 25/11/2024
Thinking about open sourcing the SQL code I used to integrate / join GA4 and Google Analytics Universal Analytics data to create our reporting datasets. It was a major unlock for our organization to have continuous web metrics before and after the cutover. Would that be useful for any of you?
110
Zach Renwick @zachrenwick.work · 16/11/2024
Has anyone implemented write-audit-publish patterns with dagster? Would be great to see some examples
010
Zach Renwick @zachrenwick.work · 07/11/2024
Dagster is awesome. Google Analytics 4 data landing time varies significantly every day, so we're building an automated sensor to trigger runs whenever the data lands vs the existing cron schedule. This will save me from having to manually trigger additional runs when data is late!
000
Zach Renwick @zachrenwick.work · 01/11/2024
Ask me about integrating GA4 with legacy Google Analytics Universal Analytics raw data Got some horror stories here that I still deal with
100
Zach Renwick @zachrenwick.work · 01/11/2024
Bad day to be an 800 line SQL query Because it's time to absolutely hammer some refactored SQL
010
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
Zach Renwick @zachrenwick.work · 01/11/2024
Reposting my greatest twitter hits sorry in advance
020