Performance Tuning

Post Image

Prompting Is Architecture: Why Understanding Systems Matters More Than Ever

A Spark story about scale, grain, and why speed makes system awareness non-negotiable.Image generated using ChatGPTRecently, I ran into a Spark job that looked perfectly fine. I used Claude in this case to generate code, which wasSyntactically correctSemantically correctEasy to read and reason aboutThis worked on the sample dataset. Assuming Spark will manage the scale, we pushed it to production. However, on prod, it took more than 3 hours to complete on a 40-node EMR cluster. It was trying to...

Read
Post Image

Designing OLAP Schemas by Query Shape

How we learned that schema purity matters less than matching the natural grain of your queries.Image generated using ChatGPTBefore we talk schema design, we need to discuss the problem. Without the domain context, the technical decisions won’t make sense.Think of the digital billboards you see on highways, in malls, airports, or gyms. Each physical screen is called a .Advertisers don’t just ask — How many people see this screen?They ask:: Physical advertising screens. In the US alone, there are millions...

Read