II.
Workflow overview
Reference · liveworkflow:data-warehouse-schema-governance
Data Warehouse Schema Governance overview
Governs schema changes to the shared data warehouse — requiring schema change proposals with impact analysis before DDL execution, validating naming conventions and type standards against the warehouse style guide, running backward-compatibility checks to ensure existing dashboards and downstream consumers remain functional, coordinating migration windows with dependent teams, maintaining a schema changelog with version tags, and enforcing column-level documentation requirements for discoverability. Produces schema change review records, compatibility test results, and warehouse schema documentation updates. Excludes ETL pipeline modifications.
Attributes
displayName
Data Warehouse Schema Governance
workflowKind
governance
triggerType
event-driven
typicalCadence
per-event
complexity
cross-team
description
Governs schema changes to the shared data warehouse — requiring schema change
proposals with impact analysis before DDL execution, validating naming
conventions and type standards against the warehouse style guide, running
backward-compatibility checks to ensure existing dashboards and downstream
consumers remain functional, coordinating migration windows with dependent
teams, maintaining a schema changelog with version tags, and enforcing
column-level documentation requirements for discoverability. Produces schema
change review records, compatibility test results, and warehouse schema
documentation updates. Excludes ETL pipeline modifications.
Outgoing edges
applies_to_domain2
- domain:data-engineering·DomainData Engineering
- domain:databases·DomainDatabases
involves_role3
- role:database-administrator·RoleDatabase Administrator
- role:data-scientist·RoleData Scientist
- role:tech-lead·RoleTech Lead
performed_by_org_unit2
- org-unit:data-governance-team·OrgUnitData Governance Team
- org-unit:database-team·OrgUnitDatabase Team
requires_skill_area2
- skill-area:data-warehouse-modeling·SkillAreaData Warehouse Modeling
- skill-area:database-migrations-zero-downtime·SkillAreaZero-Downtime Database Migrations
triggers_responsibility2
- responsibility:data-quality-monitoring·ResponsibilityData quality monitoring
- responsibility:review-architecture-changes·ResponsibilityReview architecture changes
Incoming edges
None.