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)”
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)”
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)”
With this new capability, organizations can bring their Oracle data—whether on-premises, in Oracle Cloud Infrastructure (OCI), or on Exadata—directly into OneLake, Fabric’s unified Data Lake. Meaning your Oracle data is always fresh, instantly query able, and seamlessly integrated with the rest of your analytics stack—without the complexity of traditional ETL. Integrating Oracle Data Seamlessly into OneLake … Continue reading “Mirroring for Oracle in Microsoft Fabric (Preview)”
Coauthored by: Joanne Wong Microsoft Fabric continues to evolve as a unified data platform, and the latest updates to SQL Database in Fabric as a fully managed database SaaS offering, brings a suite of application developer centric and enterprise-grade features that elevates security, flexibility, and developer productivity. Here’s a breakdown of the most impactful enhancements. … Continue reading “Unlocking Enterprise ready SQL database in Microsoft Fabric: ALM, Backup, Copilot & more”
