Lesson 4 of 6 in this module

31/33 in track

PK / FK / CHECK, and how warehouses relax them

sql12 min

Locked lessonPerformance & Production SQL

PK / FK / CHECK, and how warehouses relax them

OLTP enforces keys. Many lakes rely on tests and contracts instead. Query for violations.