Microsoft Fabric Updates Blog

OPENROWSET and External Tables for Fabric SQL Databases (Preview)

Data Virtualization (Preview) for Fabric SQL Databases, enable you to query, analyze, and ingest OneLake data (CSV, Parquet, JSON) without moving or duplicating it. Data Virtualization brings to Fabric SQL Database the same set of capabilities already available on Azure SQL Database, Azure SQL Managed Instance and SQL Server, customers can now use OPENROWSET and … Continue reading “OPENROWSET and External Tables for Fabric SQL Databases (Preview)”

How to Query Database Backups in Microsoft Fabric Without Copies or ETL

In collaboration with Peleg Kazaz, and Liore Shai Every company backs up its business-critical and operational databases. Every data-driven, AI-powered company also mirrors relevant data from its databases and consolidates it into a data warehouse for analytics and AI. These database backups contain the most complete, historical, and current view of the business, and are … Continue reading “How to Query Database Backups in Microsoft Fabric Without Copies or ETL”

Large string and binary values in Fabric Data Warehouse and SQL analytics endpoint for mirrored items (Generally Available)

Co-authored with: Ancy Philip Fabric Data Warehouse and SQL analytics endpoints for mirrored items now support large string and binary data using VARCHAR(MAX) and VARBINARY(MAX) types. Large string or binary values in Data Warehouse In Fabric Data Warehouse, this enhancement allows you to ingest, store, process, and analyze large descriptive text, logs, JSON, or spatial … Continue reading “Large string and binary values in Fabric Data Warehouse and SQL analytics endpoint for mirrored items (Generally Available)”

Introducing the HTTP and MongoDB CDC Connectors for Eventstream — Inspired by You

At Fabric Real-Time Intelligence (RTI), Eventstream empowers users to easily ingest, process, and route real-time data into RTI for dashboard and alerting. Today, Eventstream supports over 30 data sources, including streaming platforms, third-party services, database Change Data Capture (CDC), and public data feeds. We have two new connectors that we’re excited to introduce to you … Continue reading “Introducing the HTTP and MongoDB CDC Connectors for Eventstream — Inspired by You”

Mirroring: Uploading your CSVs is now simpler than ever before!

Open Mirroring in Microsoft Fabric continues to evolve, and the latest updates make working with files simpler and more powerful than ever. Previously, you were required to provide a primary key for mirrored parquet and delimited text files including CSV —now, that’s no longer necessary. Mirroring in Fabric no longer requires primary keys and automatically … Continue reading “Mirroring: Uploading your CSVs is now simpler than ever before!”