Zach R (@zachr_data) header
Zach R (@zachr_data) profile picture

Zach R

@zachr_data

Data/Analytics Engineer 📊 #SQL #data #analytics #BigQuery #GoogleAnalytics

zachrenwick.work
Joined January 2009
  • Tweets2.9K
  • Following494
  • Followers760
460Media
Photo by Zach R (@zachr_data)Photo by Zach R (@zachr_data)Photo by Zach R (@zachr_data)Photo by Zach R (@zachr_data)Photo by Zach R (@zachr_data)Photo by Zach R (@zachr_data)Photo by Zach R (@zachr_data)Photo by Zach R (@zachr_data)Photo by Zach R (@zachr_data)Photo by Zach R (@zachr_data)
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
Image from Zach R (@zachr_data)
5
1,945
Ok proud work moment, we are #1 on the App Store right now! I modelled all the tracking/telemetry data, integrating it with existing web analytics pipelines so we have one stop shop datasets for all our web/app sessions and conversion funnels
Image from Zach R (@zachr_data)
78
Me getting back into the gym
Image from Zach R (@zachr_data)
72
Holy shit, this was > 5 years ago?
Seth Rosen (@sethrosen) profile pictureSeth Rosen
@sethrosen20 Apr 2020
Them: Can you just quickly pull this data for me? Me: Sure, let me just: SELECT * FROM some_ideal_clean_and_pristine.table_that_you_think_exists
1
3
960
DuckLake is cool. Next question, how do we scale the local querying? Let my iPhone 15, laptop and desktop scale out a query on 1TB of data
1
1
294
Everyone else: LLMs are amazing, they are going to automate you out of a job Me to LLM: Return BigQuery SQL that does a thing LLM: Here is Redshift SQL Me: ???
3
193
Snowflake releasing semantic views, meaning you can semantic/metric layer directly in your cloud DW: docs.snowflake.com/en/user-g… I'm here for it, but I don't see docs yet on how you would consume from the semantic view. Maybe like select conversion_rate() from semantic_view?
1
4
262
good data > no data > bad data
1
113
just wait til you get to your 30s
10x (@10x_er) profile picture10x
@10x_er10 Apr 2025
learning how similar you are to your dad in your mid to late 20's is the most terrifying thing they never tell you
5
268
everybody wanna train a ML model but nobody wanna clean no big ass data
Image from terminally onλine εngineer (@tekbog)
55
206
17
3,602
128,957
Tech debt is good actually * Good if your middleware SQL logic enables business to know WTF was going on thru 3 site migrations and web analytics platforms
167
Anyone here used Looker (as a semantic/metrics layer) and Tableau together? How is the native Looker to Tableau connector?
1
189
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!
Image from Zach R (@zachr_data)
7
267
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.
5
17
1,198
There's so much value to add anywhere along the data chain. Honestly, blending business context (analyst focus) with data modeling is an extremely impactful role. Yes there's some shit AE models out there, but I've seen some terrible SQL written by data engineers too
1
5
243
Pro tip: mention “vanity metrics” once in a meeting and people will think you’re a freaking analytics mastermind 😮
1
5
257
It turns out taking your job a lot less seriously is good for your mental health. Who would have thought?
1
5
239
this is literally how i feel working in corporate
33
1,461
116
17,313
502,449
I thought BigQuery was pretty cool but then I learned about Databricks Delta Live Tables and Snowflake Dynamic Tables… Why we out here writing manual incremental strategies in dataform and dbt, just let the engine figure it out (didn’t realize streaming could be that easy)
7
1
55
4,013
Me when asked for too many “gee whiz” data insights Not enough scalable data infrastructure Engineers just want to build plz
Mark Manson (@Markmanson) profile pictureMark Manson
@Markmanson21 Jan 2025
You are not stressed from doing too much. You are stressed from doing too little of what you care about.
2
286
First thing you do at airport is locate your boarding gate. Doesn’t matter if your flight is 2 hours delayed. I don’t make the rules
1
3
240
Load more