dataMinds News Round up –
November 2024
Author: Jason Himmelstein
In this detailed update from Jason Himmelstein, explore the latest innovations and enhancements within Microsoft Fabric for October 2024.
Welcome to the October 2024 Update! This month brings several exciting new features to Microsoft Fabric. First, we’re thrilled to announce GraphQL API support for Service Principal Names (SPNs), making secure, programmatic access to data easier than ever. Lakehouses now offer enhanced capabilities with sorting, filtering, and searching, empowering users to interact with data in powerful new ways. Additionally, a new feature in KQL Queryset promises to revolutionize data interaction, bringing advanced query capabilities right to your fingertips.
Author: Sandeep Pawar
In his latest article, Sandeep Pawar delves into optimizing delta tables for Microsoft Fabric, sharing a robust 250+ line code solution for analyzing lakehouse and warehouse performance. Direct Lake and delta lake read/write speeds depend heavily on delta table structure—factors like rowgroup distribution, file sizes, and maintenance frequency are crucial. This code scans delta tables for insights, including file counts, operation history, and rowgroup metrics, helping users diagnose performance issues. With real-world application examples, Sandeep explains how these metrics can spotlight fragmentation issues and boost efficiency through targeted maintenance.
Author: James Serra
Author: Meagan Longoria
Meagan Longoria shares valuable insights on achieving efficient and reliable data loading with control flow restartability in Azure Data Factory (ADF). Learn how Meagan’s metadata-driven approach ensures that failed data loads don’t require reloading all tables, making it easier to pick up exactly where you left off. With a focus on control tables, logging, and stored procedures, this approach helps track and restart failed processes seamlessly. Discover how to optimize your ADF pipelines for greater efficiency and reliability in this deep dive on metadata-based control flows.
Learning
Get certified in Microsoft Fabric—for free! Fast-track your career by becoming a Microsoft Certified: Fabric Analytics Engineer Associate. The Microsoft Fabric Community team is offering 5,000 free DP-600 exam vouchers to eligible community members. Complete your exam by the end of the year and join the ranks of certified Fabric experts. Don’t miss this incredible opportunity!
Introducing a new certification for data engineers! We’re excited to announce the Microsoft Certified: Fabric Data Engineer Associate certification, designed to showcase your expertise in data ingestion, transformation, administration, monitoring, and performance optimization within Fabric. To earn this certification, pass Exam DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric, now in beta.
Microsoft Fabric and AI Learning Hackathon Ready to unleash your creativity? Join the hackathon to explore how Microsoft Fabric drives innovation, and compete for exciting prizes! Don’t forget to check out our livestreamed events for expert insights and answers to all your questions.