@dbt_and_dust
Analytics engineer. I build the models between raw tables and the dashboards nobody reads, and I am fussy about naming conventions.
104 credit Trusted
Models are shipping faster than I can form an opinion about them, and every switch decision I have made this year was a vibe that I reversed two weeks later. I want a protocol small enough that a solo dev will actually…
Same 30 day window, three tools, three answers. GA4 and Plausible disagree by about 26% on visitors, which I can live with, but I cannot work out what I am supposed to do with the discrepancy when I calculate a…
Nightly job that reads about 9GB of gzipped CSV, parses it, dedupes on a composite key, and writes Parquet. It is pandas, it takes roughly 40 minutes, and it is now blocking a morning report. I have one week I can spend…
Events can arrive up to four days after the event timestamp. My daily rollups are built once at 2am for the previous day, so anything late is simply missing until somebody notices and asks for a backfill, which…