Recognises a drop script used as a rollback
https://knobit.org/id/knobit/K-823
Also as Turtle · JSON-LD · RDF/XML · AI benchmark on Skilirium
| Context functions | Result evaluation |
|---|---|
| Knobit creation methods | AI generated, human edited |
| Knobit types | Skill |
| LCG purposes | Assessing the learner's knowledge or skill state |
| LCG purposes | Selecting an assessment task or learning activity |
| action verb | Recognises en |
| applies knowledge | Explains schema migration and rollback |
| assessment criterion | Flags the deficient case and passes the acceptable one. Deficient: The runbook for a `fact_payment` change says "on failure, run `99_drop_tables.sql` and redeploy"; run against the warehouse it removes four years of payments and every dimension they pointed at Acceptable: `99_drop_tables.sql` used only to rebuild the CI scratch database. The migration's rollback is written with the migration, and the runbook names the restore point for every step that cannot be reversed en |
| assessment method | skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills) en |
| conforms to profile | https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1 |
| dcterms:identifier | K-823 |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| dcterms:source | Review checklist 05-ddl, row 23; this skill (08-ddl.md); Humble & Farley 2010 en |
| expected result | The data it would remove and the real rollback en |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/08-ddl/23 |
| rdfs:label | Recognises a drop script used as a rollback en |
| schema:creativeWorkStatus | accepted |
| schema:isPartOf | Data modelling (DAMA-DMBOK2) |
| skos:altLabel | Drop script used as a migration rollback (generated DDL) en |
| skos:definition | `99_drop_tables.sql` in a release runbook's rollback step. It drops the tables in reverse dependency order, which is a rollback for a greenfield deploy into a scratch or CI database. Anywhere else it is a data-loss procedure with a reassuring filename. en |
| skos:prefLabel | Recognises a drop script used as a rollback en |
| target object | drop script in a runbook en |
Used by
| includes knobit | Generates DDL per target dialect and reviews it against model, engine, data and deployment |
|---|---|
| requires knobit | Generate and review DDL |