Zach R @zachr_data

Data/Analytics Engineer 📊 #SQL #data #analytics #BigQuery #GoogleAnalytics zachrenwick.work Joined January 2009

Tweets

3K
Followers

769
Following

499
Likes

5K

Zach R @zachr_data

3 months ago

Holy shit, this was > 5 years ago?

Seth Rosen @sethrosen

5 years ago

Holy shit, this was > 5 years ago?

266 4K 26K 0 580

0 0 3 788 0

Zach R @zachr_data

3 months ago

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 0 1 252 0

Zach R @zachr_data

4 months ago

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: ???

0 0 3 160 0

Snowflake releasing semantic views, meaning you can semantic/metric layer directly in your cloud DW: docs.snowflake.com/en/user-guide/… 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 0 4 233 0

Zach R @zachr_data

4 months ago

good data > no data > bad data

0 0 1 91 0

Zach R @zachr_data

5 months ago

just wait til you get to your 30s

10x’er @10x_er

5 months ago

just wait til you get to your 30s

414 8K 86K 2.7M 5K

0 0 5 239 0

terminally onλine εngineer 🇺🇦🇪🇺🇺🇸 ~ new era @tekbog

6 months ago

everybody wanna train a ML model but nobody wanna clean no big ass data

61 222 4K 128K 271

Download Image

Zach R @zachr_data

7 months ago

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

0 0 0 154 0

Zach R @zachr_data

7 months ago

Anyone here used Looker (as a semantic/metrics layer) and Tableau together? How is the native Looker to Tableau connector?

1 0 0 176 0

Zach R @zachr_data

7 months ago

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!

0 0 7 254 2

Download Image

Zach R @zachr_data

7 months ago

Pro tip: mention “vanity metrics” once in a meeting and people will think you’re a freaking analytics mastermind 😮

1 0 5 248 0

Zach R @zachr_data

7 months ago

It turns out taking your job a lot less seriously is good for your mental health. Who would have thought?

1 0 5 231 0

terminally onλine εngineer 🇺🇦🇪🇺🇺🇸 ~ new era @tekbog

7 months ago

this is literally how i feel working in corporate

34 2K 18K 497K 5K

Download Video

Zach R @zachr_data

8 months ago

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)

8 1 55 4K 24

Zach R @zachr_data

8 months ago

Me when asked for too many “gee whiz” data insights Not enough scalable data infrastructure Engineers just want to build plz

Mark Manson @IAmMarkManson

8 months ago

Me when asked for too many “gee whiz” data insights Not enough scalable data infrastructure Engineers just want to build plz

212 1K 10K 327K 2K

0 0 2 273 0

Zach R @zachr_data

8 months ago

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 0 3 233 0

Zach R @zachr_data

8 months ago

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