DE Mastery GitHub

Lakehouse & open table formats · LKH-03

Catalogs, branching & write-audit-publish

From your world. SOX: an audited publish step before data reaches the mart

Practice quiz with instant feedback. For a scored run that counts toward your local progress, use uv run de quiz LKH-03.

1What three jobs does an Iceberg catalog do?
2What is the difference between an Iceberg tag and a branch?
3In a write-audit-publish flow, WHERE do you write the new data first, and why?
4Which snapshot must the audit checks run against in WAP?
5What does CALL .system.fast_forward('db.t','main','audit') do?
6Why does the ORDER (write -> audit -> publish) matter for a SOX-style control?
7When is a WAP branch flow NOT worth it?