Built for analysis instead of transaction processing, this relational store usually links facts to dimensions using a snowflake or star layout. Microsoft's present offering is Fabric Warehouse.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Data warehouse in context, with comparison tables and the common traps.
Terms in this definition
- Fabric Warehouse
A relational data warehouse in the classic style, offered as a Fabric item, that supports T-SQL fully, transactions included.
Related terms
- Fabric workload
Microsoft Fabric groups its features into workloads, each serving a role or job, for instance Power BI, Real-Time Intelligence, Data Warehouse, Data Factory or Data Engineering; they all read and write the same OneLake data.
- Schema-on-read
Imposing a table-like structure on stored files at the point of reading them for analysis, as in a data lake, instead of when the data is saved (schema-on-write), as in a data warehouse.
- Workload
Also called an experience: a Fabric toolset aimed at one job role, e.g. Data Factory, Data Engineering, Data Warehouse, Real-Time Intelligence or Power BI. Each keeps its data in OneLake.