bcgov / bcgov/Mines-Data-Platform
Design and migrate Gold Dimension and Fact tables in MDP-DWH warehouse
- Dominant language
- HCL
- Stars
- 0
- Forks
- 1
- Avg merge
- 24m
- Merged PRs (30d)
- 1
Description
Title: Design and migrate Gold Dimension and Fact tables in MDP-DWH Warehouse
User Story:
I want to design and migrate Gold-layer Dimension and Fact tables into the Fabric MDP-DWH Warehouse,
So that business users can query trusted, optimized, and semantically consistent data for reporting and analytics.
Acceptance Criteria:
Gold Dimension tables created in gld schema with NOT ENFORCED primary keys
Gold Fact tables created in gld schema with foreign key relationships defined (NOT ENFORCED)
Data types aligned to Fabric best practices (e.g., decimal, datetime2)
Migration DDL scripts validated against source Azure DB objects
Additional Notes / References:
Reference Fabric constraints documentation: https://learn.microsoft.com/en-us/fabric/data-warehouse/table-constraints
Related tasks: BulkCopyFromDBToBronze pipeline, SourceCatalog / ETL logging
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.