Nightly Schema-Drift Digest for the Dictionary

Keeps the data dictionary honest. Every night it diffs the warehouse's real columns against what the dictionary documents and surfaces exactly what changed, so undocumented or stale entries never pile up unnoticed.

When schemas evolve faster than docs and analysts lose trust in the dictionary. Use it to assign documentation debt the morning after any schema change lands.

1. 1A scheduled trigger runs on a nightly cron.
2. 2The flow snapshots the current table and column inventory from Snowflake INFORMATION_SCHEMA.
3. 3It reads the documented columns from the Coda data dictionary.
4. 4A diff step categorizes changes: new columns missing docs, columns dropped from the warehouse but still documented, and type changes.
5. 5If nothing changed, it exits quietly; otherwise it writes the gaps back into a Coda "needs documentation" table.
6. 6It posts a Slack digest summarizing the drift with owners tagged for follow-up.