New editor improvements for Fabric Data Warehouse and SQL Analytics Endpoint
We’ve made key improvements to our new editor in Fabric Data warehouse and SQL analytics endpoint to improve the consistency and efficiency of SQL developers’ experiences!
Starting with the ribbon, the actions presented would change depending on your context in our previous editor. This lacked consistency with other Fabric tools and required extra click stops to launch a certain experience from the ribbon. To make the ribbon more intuitive, we have improved our ribbon to be unified by consolidating all dev tools in a single location split by two tabs for a streamline workflow.
The Home tab includes actions for an end-to-end developer experience starting from ingesting data with “Get data”. Once the data is ingested, you can choose to query the data using “New SQL query” and any of the provided templates or with a “New visual query”. For monitoring, you can view the status of their queries through Query activity, and you can start modeling new relationships with the “New model layout” entry point. Lastly, you can download your existing schema as a SQL project with “Download SQL database project”. The Reporting tab provides all the necessary tools regarding modeling from creating a new report to all semantic models including creating, managing and updating.
In the data grid from our previous editor, the only capability provided at a column level was the ability to sort. Our new data grid within data preview and displaying query results now provides added capabilities at the column level including sort by ascending and descending order, select, and specify values to filter out per column along with many more features to come. These capabilities can help you quickly analyze and filter your data without running any T-SQL.
We’ve listened to your feedback on scenarios where you need to look at multiple experiences at once when writing queries. For example, checking on the data in the tables and the relationships between tables in the BI models to decide how to better structure the query. Within the editor, multitasking between dynamic tabs is now supported between different experiences such as data preview, querying, and modeling. With each experience opened through a dynamic tab, you can easily toggle between each for a smoother and more efficient data analyzing experience.
The multitasking navigation between warehouses and SQL analytics endpoints has also been improved. In our previous editor, multitasking was only seamless if you were switching between the data previews in different warehouses. Now, whether you’re on a data preview, SQL query, or modeling tab, you can smoothly transition between warehouses/SQL analytics endpoints, and it persists your last activity.
