topic Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema. in Data Warehouse

SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

AJAJ — Wed, 25 Mar 2026 14:49:05 GMT

Hi there,

Wondering if there are possible alternative solutions for the below. Not sure if im the only one thinking feeling this way or everyone is happy with set up on the left and prefer to traverse thru N number of clicks to see objects from different schema.

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

deborshi_nag — Mon, 23 Mar 2026 15:40:30 GMT

Hello AJAJ

Actually there is indeed a setting in SSMS, and it controls how you want to group your objects. Starting with SSMS 22.4.1, Object Explorer can toggle schema-grouping for any SQL database.

Tools > Options > SQL Server Object Explorer > General > “Group objects by Schema”.

If it’s OFF, you’ll see the “SQL Server classic” style i.e. like this

Tables

dbo.table1

schema1.table2

Here's the page where you'll find the detail -

Open and Configure Object Explorer | Microsoft Learn

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

AJAJ — Mon, 23 Mar 2026 16:47:21 GMT

Thanks deborshi_nag i got excited and got bummed. I dont want to group by schema as mentioned in the original post. I want to group by object type since its already grouped by schema.

i want to see fabric warehouse tables to be listed out like the below which is not in the current case even though the box is not checked. are you seeing fabric warehouse without grouped by schem? if you could share screenshot that would be helpful.

dbo.table1

schema1.table2

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

deborshi_nag — Mon, 23 Mar 2026 19:39:47 GMT

AJAJ I am using SSMS 19.3, and yes I don't see them grouped by schemas. In the screenshot a1_warehouse is a Fabric sample warehouse - ref and sales are schemas.

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

AJAJ — Mon, 23 Mar 2026 19:44:52 GMT

deborshi_nag do you think you could run this and share.

select @@VERSION

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

deborshi_nag — Mon, 23 Mar 2026 20:20:20 GMT

Microsoft Azure SQL Data Warehouse (RTM) - 12.0.2

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

AJAJ — Mon, 23 Mar 2026 21:26:14 GMT

deborshi_nag Thanks. I guess once you upgrade SSMS to 20+ you might see objects getting group by schema for fabric warehouses / lakehoues like the left side of the screenshot.

I will see if anyone else is able to get SSMS to go by object name instead of schema name. Thanks for your time. As of now issue is still unresolved.

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

deborshi_nag — Mon, 23 Mar 2026 22:20:15 GMT

Can you share a screenshot of how Object Explorer appears when you untick the "Group objects by schema" option? Please restart the application when you have changed the setting.

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

AJAJ — Wed, 25 Mar 2026 14:47:19 GMT

deborshi_nag using the latest SSMS 22 available as of 03/25/2026

When i connect to "SQL Server" i see table

dbo.table1

schema1.table2

but when connected to fabric warehouse it still shows grouped by schema. as showed in screenshot top left most of this thread and its frustrating.

doesnt matter if the below is unchecked.

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

PraveenVeli — Thu, 26 Mar 2026 13:33:54 GMT

Hi AJAJ , You can just enable and disable it on the fly by using this option.

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

AJAJ — Thu, 26 Mar 2026 14:18:07 GMT

PraveenVeli Thanks for pointing it out. Never knew there is a button like that.

Anyway - is this a bug on SSMS 2022.4.1?

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

PraveenVeli — Thu, 26 Mar 2026 15:26:39 GMT

I don't know if it's expected behavior in SSMS or a bug. In VS Code I can group objects by type or by schema for Fabric Warehouses, but for SSMS Microsoft documentation on Fabric Warehouse display says objects are grouped by schema by default. I can't find a way to change that in SSMS for Fabric Warehouses right now. I'll keep researching, but if you need to view them by object type, VS Code is the better option I know of.

https://blog.fabric.microsoft.com/en-US/blog/ssms-22-meets-fabric-data-warehouse-evolving-the-developer-experiences/

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

RajeshM — Sat, 28 Mar 2026 22:47:49 GMT

During Fabcon, they presented this is a new feature of SSMS. While it looks great, I prefer the Tables,views grouping instead, especially when queries span multiple schemas.

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

Anonymous — Thu, 02 Apr 2026 11:01:12 GMT

Hi AJAJ ,
I would also take a moment to thank PraveenVeli , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

Anonymous — Mon, 06 Apr 2026 06:49:33 GMT

Hi AJAJ ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

AJAJ — Mon, 06 Apr 2026 13:33:35 GMT

Anonymous had already replied to all the comments. Issue remains unresolved with no working solution.

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

Anonymous — Wed, 08 Apr 2026 08:44:43 GMT

Hi AJAJ ,

Thanks for the patience. In SSMS 22.4.1 and newer, Object Explorer supports grouping objects by type (classic view: Tables, Views, Stored Procedures) or by schema. You can configure grouping behavior in SSMS settings under Tools - Options - SQL Server Object Explorer - General - Group objects by Schema.

If the Object Explorer view in SSMS doesn’t display objects exactly as you prefer, you can use system catalog views to list objects with type and schema information. For example, you can query sys.objects or INFORMATION_SCHEMA.TABLES / INFORMATION_SCHEMA.VIEWS to see all database objects along with their types and schemas. Additionally, the Fabric portal Data Explorer provides a graphical interface to browse warehouse objects and schemas.

For feature requests or enhancements, you can submit feedback via the Fabric Feedback portal.

Refer These Docs
https://learn.microsoft.com/en-us/ssms/object/open-and-configure-object-explorer
https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity
https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-objects-transac…

https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/tables-t…

Re: SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.

Anonymous — Tue, 14 Apr 2026 06:53:11 GMT

Hi AJAJ ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you