Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

markpm
‎12-04-2024 10:00 AM

What’s new in the Fabric SQL Analytics Endpoint?

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.

Whats_new_in_the_Fabric_SQL_Analytics_EndpointWhats_new_in_the_Fabric_SQL_Analytics_Endpoint

Video showing the new 'Metadata Sync' button

  1. 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.

Whats_new_in_the_Fabric_SQL_Analytics_EndpointWhats_new_in_the_Fabric_SQL_Analytics_Endpoint

Video showing the Last sucessful update on Onelake property

  1. 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.

Whats_new_in_the_Fabric_SQL_Analytics_EndpointWhats_new_in_the_Fabric_SQL_Analytics_Endpoint

Video showing a column mapping by ID error in the SQL Endpoint

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...

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!

0