🧰Fabric Data Warehouse
Also known as Fabric Warehouse, Microsoft Fabric Warehouse
The SQL warehouse in Microsoft Fabric. You load and change it with T-SQL.
Think of it like
It is like a filing box. Each sheet goes in its own slot and stays there.
Example
A finance team keeps its star schema in a Fabric warehouse. A nightly T-SQL script loads the new sales, and Power BI reads them with no copy.
Why it matters
Teams who know SQL Server can work in Fabric without learning Spark. Microsoft points new warehouse users here.
Definition
Common mistake
Key takeaways
- 1T-SQL. The SQL Server kind of SQL.
- 2Read and write. Add, change and delete rows.
- 3All or nothing. Changes across tables land together.