Microsoft Fabric Updates Blog

Fabric Warehouse user experience updates

Today, we are excited to share a list of user experience features that we’ve shipped within Fabric Warehouse during the month of Nov 2023, to help drive productivity and simplify the experience. The following are the list of features:

  • Clone table user experience
  • Save as view/table in Visual query editor
  • Endorsement
  • Sample loading experience enhancements
  • Viewers/shared recipients can save queries

The rest of the blog describes each of these features in greater detail.

Clone table experience (Coming soon)

Earlier, we added support for Clone tables in Fabric warehouse via T-SQL, which lets you to clone the table as of current or previous point in time. We are thrilled to share with you that we have added a simple intuitive experience within the Warehouse editor to clone tables. You can create the clone of table as of current state or previous point in time with just a few clicks. You can also select multiple tables to create respective clones, using a single action by using Clone tables context menu within Tables in the Object explorer.

For more information, check out the documentation: Clone tables in the Fabric portal – Microsoft Fabric | Microsoft Learn

Save as view/table in Visual query editor

We now provide the ability to save a visual query as a view and results of query as a table within the Fabric warehouse Visual query editor! The Visual query editor enables citizen developers with an easy visual interface to write queries against the data in your Warehouse or Lakehouse SQL endpoint. Once you have the data analyzed and would like to save your query as a view or save query results as a table for future use, you can use Save as view to create a view or Save as table menu to create a table in a few clicks. You only need to select the schema and provide an object name. You don’t have to worry about the syntax for writing a view definition or loading results into the table. This simplified experience helps you to quickly create a view or table which you can use in your data analysis.

For more information, check out the documentation: Query using the visual query editor – Microsoft Fabric | Microsoft Learn

Endorsement 

Organizations often have large amounts of data assets for sharing and reuse and it can be really challenging for users to find high quality trustworthy data. To solve this problem, Fabric allows organizations to endorse items to highlight data assets that they think are valuable and meets the organization’s quality standards. We now provide the ability for organizations to promote or certify a Warehouse or Lakehouse SQL analytics endpoint. Any item owner or member with write permissions can endorse an item, while select group of reviewers can certify items. You can choose to endorse Warehouse, SQL analytics endpoint of Lakehouse, Semantic model(default) or Lakehouse independently.

Sample loading experience enhancements

To easily get started with your Warehouse, we already provide a sample to ingest data. We have now improved the Sample loading experience by giving you more details, every step along the way such as creating tables, copying sample data to your warehouse, creating views etc. Furthermore, we have made updates in the loading pattern which gives you blazing fast performance to load sample data.

For more information, check out the documentation: Create a Warehouse sample – Microsoft Fabric | Microsoft Learn

Viewers and shared recipients can save queries

Users who are assigned to “Viewer” role within a Fabric workspace have read access to query the user tables and views within the Warehouse. Previously, viewers and shared recipients (users with whom a Warehouse was shared with readData permissions), couldn’t save their queries within the Warehouse or SQL analytics endpoint of Lakehouse. We now provide the ability for viewers and shared recipients to save their queries within ‘My queries’ folder.


Relaterade blogginlägg

Fabric Warehouse user experience updates

oktober 4, 2024 från Jason Himmelstein

We had an incredible time in our host city of Stockholm for FabCon Europe! 3,300 attendees joined us from our international community, and it was wonderful to meet so many of you in person. Throughout the week of FabCon Europe, our teams published a wealth of valuable content, and we want to ensure you have … Continue reading “Fabric Community Conference Europe Recap”

september 26, 2024 från Jovan Popovic

We’ve improved the JSON support in Fabric Datawarehouse (Fabric DW) and have added the following features in Fabric DW: The JSON_PATH_EXIST function checks if there is a value on the given path in JSON text. The JSON_OBJECT and JSON_ARRAY functions enable you to more easily create JSON objects or arrays based on a set of … Continue reading “Announcing improved JSON support in Fabric DW”