Microsoft Fabric Updates Blog

Bringing Customer-Managed Keys to Fabric Warehouse and SQL Analytics Endpoint

With this release, customers gain greater control and assurance over the encryption of their most critical analytical workloads. The Value of Customer-Managed Keys Fabric already ensures that your data is encrypted at rest using Microsoft-managed keys. But for many organizations—especially in regulated industries—encryption alone isn’t enough. They need the ability to control and manage the … Continue reading “Bringing Customer-Managed Keys to Fabric Warehouse and SQL Analytics Endpoint”

Gain End-to-End Visibility into Data Activity Using OneLake diagnostics (Generally Available)

OneLake diagnostics, makes it simple to answer ‘who accessed what, when, and how’ across your Fabric workspaces. OneLake diagnostics provides similar capabilities to Azure Blob Storage monitoring. OneLake is the data lake powering Microsoft Fabric. OneLake unifies all your data into a single virtual lake and brings together powerful features for enterprise data management: Alongside … Continue reading “Gain End-to-End Visibility into Data Activity Using OneLake diagnostics (Generally Available)”

OneLake Table APIs (Preview)

Microsoft OneLake is the unified data lake for your entire organization, built into Microsoft Fabric. It provides a single, open, and secure foundation for all your analytics workloads – eliminating data silos and simplifying data management across domains. The preview of Microsoft OneLake Table APIs, a new way to programmatically manage and interact with your … Continue reading “OneLake Table APIs (Preview)”

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)”