Please enter your information to subscribe to the Microsoft Fabric Blog.

Thanks for subscribing to the Microsoft Fabric Blog. You’ll receive email notifications when we publish new posts.

Microsoft Fabric Updates Blog

  1. Updates
  2. Data Warehouse

Resolving Write Conflicts in Microsoft Fabric Data Warehouse

Fabric Data Warehouse (DW) supports ACID-compliant transactions using standard T-SQL (BEGIN TRANSACTION, COMMIT, ROLLBACK) and uses Snapshot Isolation (SI) as its exclusive concurrency control model. All operations within a transaction are treated atomically—either all succeed or all fail. This ensures that each transaction operates on a consistent snapshot of the data as it existed at … Continue reading “Resolving Write Conflicts in Microsoft Fabric Data Warehouse”

Query and ingest JSONL files in Data Warehouse and SQL Analytics Endpoint for Lakehouse (Generally Available)

The OPENROWSET function that can read JSONL format empowers you to easily read and ingest JSONL files – for example log files, social media streams, machine learning datasets, configuration files, and other semi-structured sources. With the versatile OPENROWSET T-SQL function, you can reference and query JSONL files as if they were tables, eliminating the need … Continue reading “Query and ingest JSONL files in Data Warehouse and SQL Analytics Endpoint for Lakehouse (Generally Available)”

Simplifying file access in OPENROWSET using data sources and relative paths (Preview)

The introduction of data sources and relative paths in the OPENROWSET function unlocks a new level of simplicity and flexibility for querying files in your Lakehouse and beyond. By leveraging external data sources, you can write cleaner, more maintainable SQL queries and easily access data wherever it resides — making data engineering and analytics more … Continue reading “Simplifying file access in OPENROWSET using data sources and relative paths (Preview)”

Migration Assistant for Fabric Data Warehouse (Generally Available)

Migration Assistant for Fabric Data Warehouse is a powerful tool designed to streamline your journey to a modern, high-performance data platform. With this release, we’re making it easier than ever for organizations to migrate to Fabric Data Warehouse from any T-SQL database used for analytical work, such as Azure Synapse Analytics dedicated SQL pool, ensuring … Continue reading “Migration Assistant for Fabric Data Warehouse (Generally Available)”

Statsig Experimentation Analytics (Preview)

Accelerating Product Innovation with Statsig Analytics on Microsoft Fabric Experimentation Analytics from Statsig offers a powerful new capability that’s set to transform how product teams innovate, measure product performance and make data-driven decisions to accelerate product adoption and growth. Imagine being able to unify experimentation, feature rollout, and impact analysis in one seamlessly integrated experience. … Continue reading “Statsig Experimentation Analytics (Preview)”