bcgov / bcgov/Mines-Data-Platform
Create MDP-DWH Gold semantic model in the Fabric with DIRECT LAKE storage mode
- Dominant language
- HCL
- Stars
- 0
- Forks
- 1
- Avg merge
- 24m
- Merged PRs (30d)
- 1
Description
Title: Create MDP-DWH Gold semantic model in Fabric with Direct Lake storage mode
User Story:
I want a curated Gold semantic model in Fabric, based on Fact and Dimension tables,
So that I can build performant reports with consistent business logic using Direct Lake storage mode.
Acceptance Criteria:
All Gold Fact and Dimension tables are included in the semantic model.
Relationships (PK–FK) between Facts and Dimensions are defined in the model.
Bridge tables are created where many-to-many relationships are required.
Model is configured to run in Direct Lake mode without falling back to DirectQuery.
Model passes test queries validating row counts and sample joins.
Additional Notes / References:
Reuse the Dim/Fact tables created in gld schema.
Bridge tables may be needed for InspectedLocation, OrderStopDetail, etc.
Ensure naming standards and surrogate keys (-1 “Unknown”) are respected.
Related issues: BulkCopyFromDBToBronze, Direct Lake vs. DirectQuery experiments
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.