What's new and planned for Synapse Data Warehouse in Microsoft Fabric
Important
The release plans describe functionality that may or may not have been released yet. The delivery timelines and projected functionality may change or may not ship. Refer to Microsoft policy for more information.
Synapse Data Warehouse in Microsoft Fabric is the first data warehouse that supports multi-table transactions and natively embraces an open data format. The warehouse is built on the robust SQL Server query optimizer and an enterprise grade distributed query processing engine that eliminates the need for configuration and management. Synapse Data Warehouse in Microsoft Fabric seamlessly integrates with Data Factory for data ingestion, Power BI for analysis and reporting, and Synapse Spark for data science and machine learning. It streamlines an organization's analytics investments by converging data lakes and warehouses.
Data warehousing workloads benefit from the rich capabilities of the SQL engine over an open data format, enabling customers to focus on analysis and reporting. They also benefit from accessing data from OneLake, a data lake storage virtualization service.
Synapse Data Warehouse is in public preview. To learn more, see the documentation and visit the announcement blog.
Investment areas
| Feature | Estimated release timeline |
|---|---|
| Create zero copy table clones in warehouse UI | Q4 2023 |
| Data warehouse in deployment pipelines | Q4 2023 |
| Data warehouse REST APIs | Q4 2023 |
| Ability for viewer role and shared recipients to save queries | Q4 2023 |
| Save SQL queries as views or results as tables in the Warehouse editor | Q4 2023 |
| Warehouse monitoring | Q4 2023 |
| Data warehouse SQL security enhancements | Q4 2023 |
| Workload history and query insights | Q4 2023 |
| Fabric Mirroring - public preview | Q1 2024 |
Create zero copy table clones in warehouse UI
Estimated release timeline: Q4 2023
Building upon the T-SQL table clone command, citizen developers can create zero copy table clones using the Warehouse UI with a single click.
Data warehouse in deployment pipelines
Estimated release timeline: Q4 2023
You can use Warehouse items to automatically bind downstream items in deployment pipelines and deploy to dev, test, and production workspaces. They can also use REST APIs to compare schemas, rollback changes, and automate.
Data warehouse REST APIs
Estimated release timeline: Q4 2023
You can use public REST APIs to automate data warehouse creation, management, and administration.
Ability for viewer role and shared recipients to save queries
Estimated release timeline: Q4 2023
Viewer roles and shared recipients can create and save their queries using the warehouse editor.
Save SQL queries as views or results as tables in the Warehouse editor
Estimated release timeline: Q4 2023
You can easily save queries as SQL views or turn the query results into tables using the warehouse editor UI in a couple of clicks.
Warehouse monitoring
Estimated release timeline: Q4 2023
Using the built-in warehouse monitoring capabilities, you can view query details, monitor, and troubleshoot performance of their end-to-end solution.
Data warehouse SQL security enhancements
Estimated release timeline: Q4 2023
You can define granular row-level security for data in the data warehouse, ensuring restricted access and appropriate viewing based on entitlements.
Workload history and query insights
Estimated release timeline: Q4 2023
You can view their workload, query history, and details through built-in Views. They can also gain insights for troubleshooting and debugging long-running and frequently executed queries.
Fabric Mirroring - public preview
Estimated release timeline: Q1 2024
Mirroring enables users to seamlessly connect their data in databases and data warehouses to Microsoft Fabric without any ETL. Data is replicated as Delta tables in OneLake in near real-time and all Fabric experiences of data warehousing, data science, Power BI Direct Lake mode, copilot, etc. will work out-of-the-box. This release will support Snowflake, Azure Cosmos DB and Azure SQL DB.