← Back to the notes

Lakehouse Drill Deck

chief architect
local

Ten days, 40% input and 60% output. If a day slips, don't let it be Day 4 β€” the hands-on diagnostics are the bullet your job description names explicitly.

0 / 0

Say the answer out loud before you reveal. Recognition is not recall, and the interview tests recall.

β€”
Loading…
Click, or press space, to reveal
Session 0 Got 0 Missed 0 β€”

Draw it, diagnose it, or design it β€” against a clock, out loud, and recorded. Four minutes is the honest test of whether you can draw something while being interrupted.

Press Deal
Pick a drill type and deal a prompt.
04:00
ready

The page to read in the car park. Nothing new β€” only what you most want loaded when you walk in.

Posture

You are a consultant meeting a client, not a candidate being examined. Ask before you answer. Decide, then say what it costs. Be the most honest person in the room.

The four frameworks

Opening moves

Numbers you'll reach for

Skew investigation thresholdmax/median ≳ 5Γ—
Target file size after compaction~128 MB – 1 GB
Shuffle partition targetlow hundreds of MB
Partition a table only if≳1 TB, parts ≳1 GB
Z-order columns≀ 3–4
Delta log / deleted-file retention30 d / 7 d
Interactive auto-termination30–60 min
Typical config-only cost win15–30%

Say these as heuristics. False precision is worse than "order of magnitude, roughly X".

Signals of real experience

Do not

Currency, one line each

In service of an architecture point. Never recite the list.

Three sentences to have ready

On AI. Everyone has the same models. The differentiator is governed context and runtime control β€” a data architecture problem, not a model problem.

On cost. I don't want to make the platform cheaper, I want to make it attributable. Once spend is tagged to product teams, they optimise without anyone policing them.

On the role. The job is making architecture repeatable across engagements, so the tenth customer gets the benefit of the first nine β€” while staying close enough to the metal to be credible when something is on fire.

Last things