Findings (5)
Architecture
All development, testing, and production artifacts exist in a single workspace. A bad deployment could break production dashboards.
→ Implement 3-workspace pattern: Sales-Dev, Sales-Test, Sales-Prod with deployment pipelines between them.
Data Quality
Bronze layer tables lack schema enforcement, allowing malformed data to propagate to Silver and Gold layers.
→ Add Delta table constraints and check constraints on Bronze ingestion. Use schema evolution with mergeSchema option.
DevOps
No source control for notebooks, pipelines, or semantic models. Changes cannot be tracked, reviewed, or rolled back.
→ Connect workspace to Azure DevOps or GitHub. Enable Git integration for all Fabric item types.
Governance
No documentation of data flow from source systems through Bronze → Silver → Gold layers.
→ Generate lineage diagrams using Purview or manual documentation. Tag each table with source system and refresh frequency.
Cost
Fabric capacity is fixed at F64 with no auto-pause or scale rules. Evening/weekend usage is near zero but capacity remains allocated.
→ Configure auto-pause after 15min idle. Set up scale rules: F64 during business hours, F16 evenings/weekends.
Recommendations
1Implement dev/test/prod workspace separation with deployment pipelines
2Enable Git integration for all workspaces
3Add schema enforcement on Bronze layer tables
4Configure capacity auto-scaling to reduce weekend/evening costs
5Document data lineage from source to Gold layer