Snowflake Schema-Drift Sentinel to ClickUp Fix Task

This workflow catches silent schema drift in Snowflake before it breaks dbt builds or dashboards. Each night it pulls the actual column set for your contracted models from `INFORMATION_SCHEMA`, compares it to the column names, data types, and nullability declared in your dbt contract, and files a single ClickUp task enumerating every mismatch. Clean runs produce nothing, so the only signal an operator ever sees is real drift.

Use it when upstream teams own the tables your dbt models read and can change columns without telling you. It is the right fit for warehouses where a renamed or retyped column would otherwise surface as a failed dbt run hours later, or as a wrong number on a board.

1. 1A nightly schedule fires before the dbt build window.
2. 2Query Snowflake `INFORMATION_SCHEMA.COLUMNS` for every contracted model's live shape.
3. 3Load the committed dbt contract definitions from the repo.
4. 4Diff live vs. contract: flag added, dropped, retyped, and nullability-changed columns.
5. 5If the diff is empty, exit quietly.
6. 6Open a ClickUp task per affected model with the exact column deltas and the owning team assigned.