Microsoft Fabric Updates Blog

Microsoft Fabric logo
Microsoft Fabric logo

Manage environment configuration in Fabric User data functions with variable libraries 

Data Engineers working with Microsoft Fabric often need to manage environment-specific configurations, including the modification of Lakehouse names, file paths, or schema names for development, testing, and production environments. In this scenario, you would want to avoid hard coding this information. This is where variable libraries in Fabric can help data engineers manage their environment configuration when working with Fabric User data …

Announcing Copy Job Activity in Data Factory Pipeline (Generally Available)

This milestone marks a major step forward in unifying and simplifying data movement experiences across Data Factory. With Copy Job Activity, users can now enjoy the simplicity and speed of Copy Job while leveraging the orchestration power and flexibility of Data Factory pipelines. What is the Copy job Activity  Copy Job Activity allows you to …

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 …

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 …

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 …