bcgov / bcgov/Mines-Data-Platform

Create MDP-DWH Gold semantic model in the Fabric with DIRECT LAKE storage mode

Open
#320 0 comments 0 reactions 1 assignee Claimed by @vrutstein View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.