RowHash (change detection hash) ·
SystemAddedDate / SystemUpdatedDate (D365 timestamps) ·
WarehouseAddedDate / WarehouseUpdatedDate (warehouse load timestamps).
DIMNONPERSISTED
Views over the Silver Lakehouse that expose dimension-shaped data without physical persistence in the Gold Warehouse. Used where data volumes are manageable and the overhead of a persisted table is not justified. Consumed directly by the semantic model.
FACTNONPERSISTED
Views over the Silver Lakehouse that expose fact-shaped data without physical persistence. Used for supplementary transactional datasets where real-time Silver access is preferable to a scheduled warehouse load.
STAGINGNONPERSISTED
Non-persisted views that reshape and prepare Silver Lakehouse data for external consumption or downstream tooling. Not part of the dimensional model — consumed externally (e.g. by Azure Data Factory or other orchestration processes).
REPORTINGNONPERSISTED
Non-persisted reporting views that do not fit the standard DIM/FACT model. Expose pre-shaped analytical datasets for specific report requirements without adding to the core dimensional schema.