Microsoft Fabric Updates Blog

What’s new in the Fabric SQL Analytics Endpoint?

• Data Engineering
• Data Warehouse
• Lakehouse
• Uncategorized

• diciembre 4, 2024 por Mark Pryce-Maher (HE / HIM) 55.722 Vistas

As part of our continuous effort to enhance the Fabric SQL experience, we’ve introduced several updates to improve both functionality and user experience.

Here’s an overview of the latest features:

1. Metadata Sync triggered on SQL Endpoint Open
   To streamline operations, metadata synchronization between the Lakehouse and SQL Analytics Endpoint is now automatically triggered when the SQL Endpoint is opened. This ensures your SQL Analytics Endpoint remains up to date without the need for manual syncs, making it a more seamless experience.
2. ‘Refresh’ button renamed to ‘Metadata Sync’
   We’ve updated the ‘Refresh’ button on the ribbon to ‘Metadata Sync’ for improved clarity. This change helps users understand that the button initiates a manual metadata refresh between the Lakehouse and the SQL Endpoint, rather than just refreshing the object explorer.

3. Last successful update on OneLake
   You can now view the ‘Last Successful Update’ in OneLake directly from the table properties dialog flyout on the SQL Endpoint. This new feature provides greater visibility into your data, making it easier to track the most recent successful updates from within the properties panel.

4. Improved error propagation
   We’ve enhanced the way errors are reported by improving error propagation. The new system delivers more detailed and clear error messages, making troubleshooting and debugging more efficient and effective.

What’s coming soon? 

Public REST API to manually execute the synchronization process.

Next Steps:

Learn more about the synchronization process: SQL analytics endpoint performance considerations – Microsoft Fabric | Microsoft Learn

Learn about the delta features supported in each engine in Fabric: Delta Lake table format interoperability – Microsoft Fabric | Microsoft Learn

Check out our Data Warehouse roadmap: What’s new and planned for Synapse Data Warehouse in Microsoft Fabric – Microsoft Fabric | Microsoft Learn

Have a feature request? Post your thoughts to Ideas (microsoft.com).

Check out our vibrant Reddit community: Microsoft Fabric

Thank-you to everyone in the Microsoft Fabric Community in this exciting journey to make data more accessible, understandable, and actionable for everyone in your organization. Thanks for reading!