serving-schema-review
serving-schema-review
Reviews a concrete application-serving schema — CREATE TABLE statements, an ERD, table definitions, or a written data contract — for a layer built on an analytics gold layer and consumed directly by an application. The failure this fixes: generic schema reviews check normalization and naming but miss the serving-layer-specific defects that actually take these systems down — writes aimed at replicated tables, key hygiene a managed sync silently punishes, freshness SLAs the sync mode cannot meet, evolution plans that break on the first rename, and tenant/PII enforcement that no layer owns.
Platform-independent: vendor behaviors (Databricks Lakebase, Microsoft Fabric, self-managed Postgres+CDC) are cited as examples of the category, never assumed.