Manage objects in your data warehouse
Applies to: ✅ SQL analytics endpoint, Warehouse, and Mirrored Database in Microsoft Fabric
This article describes warehouse management tasks you can accomplish in the Explorer in the Microsoft Fabric portal.
- You can organize, explore, and manage warehouse objects in the object explorer, and execute queries in the SQL query editor.
- You can also query the data in your warehouse with multiple tools with a SQL connection string.
- You can build queries graphically with the Visual query editor.
- You can quickly view data in the Data preview.
The Explorer provides a hierarchical view of the warehouse objects, including schemas, tables, views, stored procedures, and more. The objects are organized by schema then object type.
Search and filter objects in the explorer
The search and filter features in Fabric Data Warehouse are designed for ease of discovery.
The search function quickly highlights matching objects and highlights the results within the object explorer for the user.
When dealing with numerous objects, such as schemas, tables, or stored procedures, finding specific items can be challenging. Use the filter options for object selection based on object type or created date.
Script out warehouse objects in the explorer
Use Explorer to create, alter, and drop objects using T-SQL templates. You can also alter or drop objects using context menu options on each object. Each context menu option results in a new T-SQL query that you can execute to manage any object in the warehouse. To script out a T-SQL command for a database object, select the context menu.
Manage objects in other tools
You can manage your warehouse objects in other tools, including SQL Server Management Studio (SSMS) or the SQL Database Projects extension in Visual Studio Code. The SQL Projects extension enables capabilities for source control, database testing, and schema validation. To connect to your warehouse, see Connectivity to data warehousing in Microsoft Fabric.
For more information on source control for warehouses in Microsoft Fabric, including Git integration and deployment pipelines, see Source Control with Warehouse.
Queries
Users can manage their queries efficiently under "My Queries" and "Shared Queries" sections.
My Queries is a personal space where users can save and organize their own queries.
Shared Queries is a collaborative space where users can share their queries with team members to access, review, and execute shared queries. Anyone with Viewer and higher permissions at a workspace level can view and edit shared queries.