Fabric Data Warehouse Roadmap

Fabric Data Warehouse, one of the main Fabric experiences, provides a SQL-based database solution where developers can create and manage traditional relational data warehouses to hold transactional data. They can build integration pipelines to ingest data, run scheduled and ad-hoc high-speed aggregations, and access the data warehouse through external applications and tools. As part of Fabric, Data Science uses the same UI, workspaces, and data storage components as the other Fabric experiences, allowing it to participate in end-to-end workloads.

Product: Fabric Data Warehouse

Near Term (2024–2025)

The near-term roadmap for Data Warehouse will focus on improving compatibility with SQL Server. Although the service is based on open-source technologies, relies on Apache SQL, and the data resides in a data lake, Microsoft is intent on the service becoming the replacement for Synapse SQL Dedicated pools. The challenge is that the older service is based on Microsoft’s SQL Server product, which is a very mature and high-performance product, developed over several decades.