DEV Community

Discussion on: 7 SQL checks I run before UAT sign-off (with queries you can copy)

Collapse
 
alexshev profile image
Alex Shev •

Pre-UAT checks are most valuable when they encode the business invariants behind the tables. Alongside counts and null checks, reconcile control totals to the source system, test idempotent reruns, and sample the newest boundary records. Those catch the quiet data-shape failures that a happy-path UI run can miss.

Collapse
 
prachitparikh profile image
Prachit Parikh •

Idempotent reruns is a great add. Load the same file twice and the totals shouldn't move. If they do, you've found the duplicate problem before a user does. And "control totals" is a phrase finance teams already use, so it lands well in a sign-off meeting.