SQL quality checks before the notebook (step 7/7) · sql for ml datasets

Checkpoint

One last thing before we move on. Same surface as a write step — but the lesson doesn't complete until this passes.

Checkpoint. Write quality_gate(db) running three checks — duplicates == 0, no NULL amounts, label rate strictly between 0 and 1 — and returning a list of failure strings (empty = pass). Print each failure, then the verdict. A gate that can't fail loudly isn't a gate.

Checkpoint

One last thing before we move on. Same surface as a write step — but the lesson doesn't complete until this passes.

full-screen editor opens — close anytime to keep reading.

SQL quality checks before the notebook — step 7 of 7