Zach R (@zachr_data) 's Twitter Profile
Zach R

@zachr_data

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

ID: 19640612

linkhttp://zachrenwick.work calendar_today28-01-2009 07:26:50

2,2K Tweet

760 Takipçi

500 Takip Edilen

Zach R (@zachr_data) 's Twitter Profile Photo

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

Zach R (@zachr_data) 's Twitter Profile Photo

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

Zach R (@zachr_data) 's Twitter Profile Photo

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

Zach R (@zachr_data) 's Twitter Profile Photo

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)

Zach R (@zachr_data) 's Twitter Profile Photo

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

Zach R (@zachr_data) 's Twitter Profile Photo

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!

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!
Zach R (@zachr_data) 's Twitter Profile Photo

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

Zach R (@zachr_data) 's Twitter Profile Photo

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

Zach R (@zachr_data) 's Twitter Profile Photo

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?

Zach R (@zachr_data) 's Twitter Profile Photo

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

Zach R (@zachr_data) 's Twitter Profile Photo

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