Explains testing DDL by execution and detecting drift

K-859 · Knowledge knobit · Activity: Generate and review DDL · Competence: Data modelling

DDL is proven by running it, and the deployed catalogue compared with the model.

Can AI do this?

Not tested yet

No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.

What it looks like in practice

Expected result: DDL is proven by running it, and the deployed catalogue compared with the model

How it is assessed: Designs the execution test and drift check for sample deployments

Related knobits

Builds on

• K-914 Explains forward and reverse engineering of data models

Needed for

• K-825 Recognises SQL reviewed without being run
• K-826 Recognises undetected drift between database and model

All 33 knobits of Generate and review DDL.

Source: Data-management practice used by the stage 8 reference and review checklist