Forum Discussion
SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.
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…
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.
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.
deborshi_nag do you think you could run this and share.
select @@VERSION
Microsoft Azure SQL Data Warehouse (RTM) - 12.0.2
