learn-when-ai-with-phoebe / Session 2 of 6
Learn When AI with Phoebe · Session 2 of 6

The almost-free tier

Session 1 sorted the backlog; tonight you price the biggest pile. The same 10 GB question costs about six cents as a query and five figures as tokens, and the gap is not a discount - it is a different kind of correctness. BI, SQL, and rules are the tier where you verify the logic once and then run it forever for cents, which is exactly why every other tier has to earn its way past them.

🟢 Easy Leaders deciding where AI budget goes Practitioners routing their own work 45 min
0-3 · Welcome 3-22 · The economics of verified-once 22-40 · Build-along: price three workloads 40-45 · Q&A
Part 0

Where session 1 left you

You walked out of session 1 with the two-question test and a backlog in three piles: 4 deterministic, 3 pattern, 3 judgment for Cadence, and your own version for your own week. Tonight is about the deterministic pile - the biggest one, and the one most often insulted with a tool it never asked for.

★ What you walk out with tonight. The math that makes the deterministic tier almost free, walked by hand until it is yours. Rogati's hierarchy of needs mapped onto Cadence's actual stack. And the honest limits of this tier - both the work it must hand up the ladder, and the ways it quietly fails on its own.

LiveThe pile everyone skips past on the way to the demo3 min▶

Four of Cadence's ten workloads - yesterday's DAU, monthly revenue by plan, cards that failed three times, the weekly reconciliation - passed both questions from session 1. The logic is writable, the definitions are aligned. That makes them deterministic, and deterministic work has a superpower no probabilistic tool can buy: you verify it once, and then it is simply correct, every run, forever.

This session exists because that pile is where routing discipline pays fastest. In the simulator, moving just these workloads off the LLM and onto queries is a big part of how the true monthly cost falls from $2,315 at baseline to $224 with the free tier on - while trusted answers go from 0 out of 10 to 4 out of 10. Cheaper and more trustworthy at the same time is not a trade-off. It is what fit looks like.

Self-studyWhat "free" means here, precisely2 min▶
  • Almost free at the margin. Building the query and arguing about the definition costs real hours. Running it again costs cents, and often literally nothing.
  • Free of verification debt. A verified query does not need an eval set, a monitoring owner, or a cleanup budget. Those line items exist only above this tier - session 5 prices them.
  • Not free of maintenance. Definitions drift and dashboards sprawl. Part 3 is honest about that, because a course that only flatters its favorite tier is an advertisement.
Part 1 · covers the verified-once economics

Six cents one way, five figures the other

8 min live

One question, two routes, and a price gap so large it stops being a price comparison and becomes a category lesson. All prices as of Sept 2026.

The same 10 GB question as a scan as tokens Route 1 · SQL scan ~$0.06 BigQuery on-demand, $6.25 per TiB scanned first 1 TiB each month is free as of Sept 2026 Route 2 · LLM input tokens $12,500+ 10 GB of text is roughly 2.5B tokens at ~$5 per million input tokens before a single output token verified once → runs forever re-verified every single run The gap is roughly 200,000x, and it is not a pricing quirk: a scan touches bytes once with logic that was already proven. Tokens pay for fresh judgment on every run, whether the run needs it or not.
🔍 Click to zoom - the same question, two routes, and a 200,000x gap that is really a category difference
LiveThe math, walked by hand4 min▶

BigQuery's on-demand price is $6.25 per TiB scanned, and the first TiB every month is free. A 10 GB scan is 10/1024 of a TiB, so about six cents - and in most real months it lands inside the free TiB and costs nothing at all.

Now push the same 10 GB through a frontier model as input. Text runs roughly four characters per token, so 10 GB is on the order of 2.5 billion tokens. At around $5 per million input tokens, that is $12,500 and up in input alone, before the model has said a word back. Same bytes, same question, five orders of magnitude apart. All figures as of Sept 2026 - prices move, so date-stamp yours too.

Nobody actually pastes 10 GB into a prompt. Real teams sample, chunk, and summarize - and each of those steps is a human deciding what matters, which is the query's job, done worse. The 10 GB framing is honest about the underlying rates: per byte of data considered, scans are priced like plumbing and tokens are priced like consulting.

LiveWhy "verified once" is the property that matters3 min▶

The price gap is the headline, but the trust gap is the lesson. A query is correct by construction: the logic was checked against the data once, and the same logic runs every time after that. Anyone who can read SQL can audit it. When it breaks, it breaks loudly - a failed job, an empty table - not fluently.

A probabilistic answer, however good, has to be re-earned on every run. That is what an eval set is: rent, paid monthly, on trust the deterministic tier gets for free. This is why the routing test from session 1 asks about verifiability before anything else - it is the single property that decides whether trust is a one-time cost or a subscription.

Self-studyKozyrkov's boundary line3 min▶

Cassie Kozyrkov, Google's former chief decision scientist, draws the boundary this course routes by: do not use machine learning for problems that are "defined by human-made rules in the first place". If a human wrote the rule, a human can write the code - directly, checkably, once. ML earns its place only when you cannot articulate the rules yourself and you have the data to learn them from.

Her broader point is that reaching for the fancy tool first is not ambition, it is a tax: the simplest approach that actually works is the one that ships fastest, audits cleanest, and leaves budget for the problems that genuinely need learning. Cadence's deterministic pile sits entirely on the human-made-rules side of her line - every one of those four workloads has a definition somebody wrote down in a meeting.

Part 2 · covers the hierarchy of needs

The pyramid under every AI ambition

5 min live

Monica Rogati drew the data hierarchy of needs in 2017: five layers of unglamorous work, and AI at the tip. Tonight we hold it against Cadence's actual stack, rung by rung.

ROGATI, 2017 CADENCE'S STACK, RUNG BY RUNG AI LEARN/OPTIMIZE AGGREGATE/LABEL EXPLORE/TRANSFORM MOVE/STORE COLLECT 3 judgment workloads: tickets, drafts, transcripts (session 4) churn, forecast, anomalies: the pattern pile (session 3) dashboard tiles: DAU, revenue by plan, failed cards - tonight SQL models and the metric definitions the teams agreed on one warehouse, one events table everything reads from app events, note uploads, billing records Rogati's framing: AI is the self-actualization of the data hierarchy, and you need food, water and shelter first. Cadence's tonight-work lives on the middle rungs. The tip is real - and it is session 4.
🔍 Click to zoom - Rogati's pyramid with Cadence's stack mapped onto every rung
LiveMost orgs reaching for the tip are skipping meals3 min▶

Rogati's layers, bottom to top: collect, move/store, explore/transform, aggregate/label, learn/optimize, and AI at the tip. Her point is not that the tip is bad - it is that the tip is self-actualization, and self-actualization on an empty stomach is called hallucinating. An org that cannot agree what "active user" means is not one clever model away from anything.

The pyramid is also a budget map. The lower rungs are exactly the almost-free tier from Part 1: verified once, run forever. Every dollar of trustworthy AI at the tip is standing on rungs somebody funded and maintained. Skipping them does not save the money - it moves the cost into cleanup, which is the most expensive line in session 5's true-cost math.

Real world

Cadence's DAU incident from session 1, revisited with tonight's lens: the LLM summarizer returned a plausible number that was wrong by six percent - and the correct answer was already sitting behind an unused dashboard tile, computed nightly, verified months earlier, for less than a cent. The org had built the aggregate/label rung and then forgot it existed. The pyramid was fine. The routing was not.

Self-studyReading your own org's pyramid honestly3 min▶
  • Collect and move/store are healthy if one system of record exists per fact and nobody exports to spreadsheets to "fix" the numbers.
  • Explore/transform is healthy if metric definitions live in code that is reviewed, not in the heads of the two people who have been there longest.
  • Aggregate/label is healthy if the dashboards people actually open answer the questions people actually ask - Part 3 covers what happens when they drift apart.
  • A hole in any rung is a routing fact. It does not mean "no AI ever". It means the AI above the hole inherits the hole, plus interest.
Part 3 · covers the tier's honest limits

What the free tier cannot do, and how it fails on its own

6 min live

A router that only ever routes downward is broken in the other direction. The free tier has a hard ceiling - and its own native failure modes that no amount of loyalty should excuse.

The free tier owns this outright Metrics with written definitions DAU, revenue by plan - verified once, cents forever Threshold rules cards failed 3+ times: a WHERE clause, not judgment Reconciliations and audits two systems compared row by row, loudly wrong if wrong It must hand this up the ladder Theming 500 support tickets "app eats my notes" never matches "data loss" Prediction from history churn, forecasts: no writable rule - session 3's pile Drafting and synthesis no table contains the answer - session 4's pile The tier's own failure modes - it does not need an LLM to go wrong Dashboard sprawl: 40 tiles nobody opens, so the one right answer hides in plain sight. Stale definitions: the query is still correct against a definition the business quietly abandoned. The ceiling and the failure modes are different problems. The ceiling means hand the work up. The failure modes mean maintain the rung you are standing on. Neither is an argument for the other.
🔍 Click to zoom - what the free tier owns, what it hands up the ladder, and how it fails all by itself
LiveA dashboard cannot theme a support ticket3 min▶

Cadence has 500 support tickets a month and a leader who wants to know what customers are angry about. The free-tier reflex is a keyword count: tally "crash", "sync", "billing". And it fails in a specific, predictable way: keyword counts miss every paraphrase. The customer who writes "the app eats my notes" is describing data loss, and the string "data loss" appears nowhere in the ticket. The count comes back confident, complete-looking, and wrong about exactly the tickets written by the angriest, least jargon-fluent customers.

This is a genuine no on Q1 from session 1: there is no writable rule for meaning. Language work belongs on the language tier, and session 4 prices what doing it properly costs and earns.

Self-studyRules impersonating judgment, and the tier's own rot4 min▶
  • Rules impersonating judgment. A 300-line regex for extracting action items from meeting notes is not the free tier - it is judgment work in a deterministic costume. It carries the maintenance burden of code and the accuracy of a guess, which is the worst seat in the house.
  • Dashboard sprawl. Every unanswered question spawns a tile; nobody deletes tiles. The DAU incident happened partly because the right tile existed and nobody could find it among the forty others. A dashboard nobody opens is a query nobody verified recently.
  • Stale definitions. The query stays correct against the definition it encodes - while the business moves the definition in a meeting the data team was not in. Verified once is a superpower with one clause: it holds until the definition changes, so definition changes must reach the code.

Honest routing cuts both ways. The free tier deserves the deterministic pile - and it has to keep earning it with maintenance, pruning, and definitions that stay aligned.

Build-along

Price three workloads by hand

★ 18 min · everyone builds

Cadence's three query-shaped workloads, priced with nothing but the public rate card and arithmetic you can do on paper. All rates as of Sept 2026. Keep the numbers - session 5 puts the LLM routes next to them on the same page.

Write the formula once: monthly cost = GB scanned per run x runs per month / 1024 x $6.25. That is the whole pricing model for on-demand scans. Below it, write: first 1 TiB each month is free.

Price the DAU daily query. 0.4 GB per run, 22 runs a month = 8.8 GB scanned. 8.8 / 1024 x $6.25 = about $0.05 a month. Say it out loud - the daily number the whole company stands up around costs a nickel a month.

Price the other two. Revenue by plan: 1.2 GB x 4 runs = 4.8 GB = about $0.03. Failed-cards rule: 0.1 GB x 30 runs = 3 GB = about $0.02. All three together: 16.6 GB, roughly ten cents - and since 16.6 GB sits far inside the free first TiB, the actual invoice is $0.00.

Write the acceptance test line for each. DAU: "must equal the count of distinct users with at least one event yesterday". Revenue by plan: "plan rows must sum to the month's total invoiced revenue". Failed cards: "every card with three or more failed charges this week appears exactly once". If you can write the line, you can verify it once - that is the property you are buying.

Repeat for one workload of your own. Pick the most-asked question on your team, estimate the scan honestly, run the formula. Most people's first reaction to the result is to check the math. The math is fine. The reaction is the lesson.

Bring these three prices to session 5. The cost session runs the same three workloads through the token math on real model prices, then adds the lines nobody budgets - evals, monitoring, cleanup - so the comparison is finally apples to apples. Tonight's nickels are the baseline everything else gets measured against.

Homework

Before session 3

30 min
  1. Price every workload in your deterministic pile with the formula from the build-along - a real scan estimate and a real monthly number, even if the number is embarrassing in how small it is.
  2. Write the acceptance test line for each one. Any workload where you cannot write the line does not belong in the pile - move it, and note which pile it actually wants.
  3. Audit one dashboard for sprawl. Count the tiles; count the tiles opened in the last month. The gap is your org's version of the unused DAU tile.
  4. Find one stale definition. Ask the owner of a metric when its definition last changed, then ask when the query last changed. If those dates disagree, you have found Part 3 in the wild.
  5. Optional: skim Rogati's original hierarchy of needs essay and mark, for your own org, the lowest rung with a hole in it.
Check yourself

Three questions

Clear all three and session 2 gets stamped in your passport.

1 · The same 10 GB question costs about $0.06 as a query and $12,500+ as LLM input. What drives the gap?

$6.25 per TiB versus roughly $5 per million input tokens - 10 GB is ~2.5 billion tokens, so $12,500+ before any output (as of Sept 2026). Batch and cache discounts shave the token bill but cannot close five orders of magnitude, because the routes sell different things: one runs proven logic, the other re-buys judgment per run.

2 · Bottom to top, Rogati's hierarchy of needs runs:

Collect at the base, then move/store, explore/transform, aggregate/label, learn/optimize, and AI at the tip. Her framing: AI is the self-actualization of the data hierarchy, and you need food, water and shelter first. Option C is what the pyramid was drawn to prevent.

3 · A ticket reads "the app eats my notes". Why does the free tier's keyword counter fail here?

"App eats my notes" is a data-loss report that never matches "data loss". Adding "eats" catches one phrasing and misses the next thousand - chasing paraphrases with keywords is judgment work in a deterministic costume. This is a genuine no on Q1, which is precisely what hands the work up the ladder.

Sources covered

What this session teaches, and where it came from

✓BigQuery on-demand pricing$6.25 per TiB, first TiB free, and the $0.06 vs $12,500+ course math - all date-stamped Sept 2026
✓Rogati, The AI Hierarchy of NeedsAll six layers walked against Cadence's stack, with the self-actualization framing
✓Kozyrkov on when not to use MLThe human-made-rules boundary applied to the deterministic pile, paraphrased faithfully
◐Official API pricing, Sept 2026Used here only for the input-token rate; session 5 does the full token math on real model prices

Every fact on this page, and its verification tier, is recorded in the course's source map.

Session 2 cheat sheet · pin this

The six-cent question10 GB scanned: ~$0.06 at $6.25/TiB. The same bytes as LLM input: ~2.5B tokens, $12,500+. As of Sept 2026.
Verified onceCorrect by construction: logic checked against the data once, then runs forever. Anyone who reads the logic can audit it.
Kozyrkov's boundaryProblems defined by human-made rules get code, not ML. ML is for rules you cannot articulate but have data to learn.
The pyramid, bottom upCollect, move/store, explore/transform, aggregate/label, learn/optimize, AI. The tip is self-actualization - eat first.
The paraphrase test"App eats my notes" never matches "data loss". When paraphrase kills the keyword list, the work goes up the ladder.
The tier's own rotDashboard sprawl and stale definitions are the free tier's native failure modes. Maintain the rung you stand on.