Learn
schema-drift
2 registry resources · 1 tutorial, 1 runbook · roadmap: Python + SQL, Data Quality
What this topic covers
DE//AGENT currently lists 2 resources under schema-drift: 1 tutorial, 1 runbook. Everything below is derived from the live registry — counts, capabilities, verification state and security posture come from the curated records, never from marketing copy.
What you can learn here
Documented learning objectives across these resources:
- Spot NULL-unsafe `NOT IN` and `=` predicates and rewrite them with NOT EXISTS — via Production gotchas — NULL traps, implicit casts, silent drift
- Make every cross-type comparison an explicit cast, not an implicit one — via Production gotchas — NULL traps, implicit casts, silent drift
- Classify a schema drift failure as hard (job error) or silent (nulls) — via Production gotchas — NULL traps, implicit casts, silent drift
Where this fits in the learning roadmap
These resources map to stages: Python + SQL (1), Data Quality (1). Follow the four-phase roadmap to place this topic inside a progression instead of learning it in isolation.
Compare the registry's options
Every entry, its shape and its trust state — sorted by the registry's composite score. This table is the honest version of a marketing comparison: no sponsored placements, no unverifiable claims.
| Resource | Type | Difficulty | Verification | Score |
|---|---|---|---|---|
| Schema drift | Runbook | intermediate | community flags | 34.75 |
| Production gotchas — NULL traps, implicit casts, silent drift | Tutorial | intermediate | community | 34.15 |
How scores are computed: source quality score.
Where to start
Highest composite score first:
- Schema drift score 34.75 — intermediate
- Production gotchas — NULL traps, implicit casts, silent drift score 34.15 — intermediate
Scores rank provenance, completeness and trust — read how verification works before adopting anything.
Cautions and limitations
Security-flagged entries: Schema drift (2 flags). Flags mean the record declares capabilities like credential use or write access — read the security posture on each page before connecting.
Production use cases
- Production gotchas — NULL traps, implicit casts, silent drift — The bugs that survive testing compare wrong instead of failing loud: NOT IN over a nullable subquery, a comparison across types left to an implicit cast, and a schema change that s… details
Further study
Study path: the roadmap places this topic in a progression · the scoring model explains the numbers · the trust rule catalog shows every security check these entries passed through.
Full resource list
| Resource | Type | Score |
|---|---|---|
| Schema drift | Runbook | 34.75 |
| Production gotchas — NULL traps, implicit casts, silent drift | Tutorial | 34.15 |