Cost Engineering

Data platforms get expensive quietly. The drivers — bytes scanned, bytes shuffled, bytes retained, hours held, work repeated — and the design decisions that move each one.

What Actually Drives Data Platform Cost

Storage, scans, shuffle, compute hours, network, retention, file count and repeated work — put in the order they actually move the number.

Q · A platform's spend grew faster than its data did. Which drivers moved, and how would you find out which one rather than guessing?
Scan Cost
▶ lab

What a query actually has to read, and why column selection and partition pruning are the two cheapest fixes in the entire domain.

Q · Two queries return the same three numbers. One reads a single day of two columns and the other reads a year of everything. What in the SQL decides which one you wrote?
Compute Waste

Rebuilding history that did not change, refreshing models nobody reads, holding capacity nobody uses, and shuffling data that did not need to move.

Q · Your platform spends most of its compute recomputing things that have not changed. How would you prove that, and which of the four shapes of waste is dominant?
Storage Lifecycle

Hot to warm to cold to archive to deleted, driven by how the data is actually read — and the retrieval cost that makes archive a trap for anything you might read again.

Q · Which of your data has not been read in a year, and what would it cost you — in money you cannot see and in latency you have not measured — to have put it somewhere cheaper?
Cost Attribution

You cannot manage what you cannot attribute — and in a shared platform every cost belongs to everyone, which means it belongs to nobody.

Q · A shared warehouse serves eleven teams. Which of them caused this month's increase, and what would it take to answer that without starting an argument?
Cost vs Freshness
▶ lab

The most direct trade in the platform: every increment of freshness is bought with compute that runs more often, longer, or continuously. The right freshness is set by the decision the data drives, never by what the stack can achieve.

Q · A consumer asks for this dataset to be fresher. What exactly gets more expensive, and what decision would have to change for that to be worth it?