Zach Renwick @zachrenwick.work · 10/02/2025Anyone 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/2025Is 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/2025Another 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/2025BigQuery 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/2025Complex 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/2025I'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/2025Perpetually 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/2025Some of you have never had to fight for BigQuery slots and it shows 010
Zach Renwick @zachrenwick.work · 30/12/2024Google 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/2024Pretty 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.socialHow to verify your Bluesky account - BlueskyHere's how to verify your Bluesky account by setting your website as your username. 000
Zach Renwick @zachrenwick.work · 27/12/2024It’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.comCanadian fintech startup Bench announces abrupt closure | NationalBench, North America's largest bookkeeping service for small businesses, has suddenly closed, leaving employees and clients scrambling. 120
Zach Renwick @zachrenwick.work · 23/12/2024New [mountain] bike day! This thing is a beast, looking forward to the bigger brakes and suspension for north shore riding 020
Reposted by Zach RenwickThe Onion @theonion.com · 04/12/2024Standing Desk Celebrates 4th Year At Lowest Possible Setting 9711218669
Reposted by Zach Renwickarchie.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/2024Sorry, how much?!? techcrunch.com/2024/12/17/d...techcrunch.comDatabricks raises $10B as it barrels toward an IPO | TechCrunchDatabricks, 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/2024Soemthing 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/2024Am 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/2024Sick 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/2024Crazy 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/2024Thinking 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/2024Has anyone implemented write-audit-publish patterns with dagster? Would be great to see some examples 010
Zach Renwick @zachrenwick.work · 07/11/2024Dagster 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/2024Ask 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/2024Bad 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/2024One 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