topic Re: Indexing not supported in Fabric datawarehouse? in Data Warehouse

Indexing not supported in Fabric datawarehouse?

duttasoumya — Fri, 07 Jul 2023 15:26:34 GMT

Following the documentation at, Primary, foreign, and unique keys - Microsoft Fabric | Microsoft Learn

The following T-SQL to create an index on my table TestIndex with a field Id

DROP TABLE IF EXISTS [dbo].[TestIndex]; CREATE TABLE [dbo].[TestIndex] ( [Id] int NOT NULL, [Name] varchar(10) NULL ); ALTER TABLE [dbo].[TestIndex] ADD CONSTRAINT PK_TestIndex PRIMARY KEY NONCLUSTERED (Id) NOT ENFORCED;

led to,

Well, if creation of indexes is not supported, should it not be included in the set of limitations documented at,

T-SQL surface area - Microsoft Fabric | Microsoft Learn

Re: Indexing not supported in Fabric datawarehouse?

Anonymous — Tue, 11 Jul 2023 23:27:26 GMT

Hi duttasoumya Thanks for posting your question in Microsoft Fabric CommunityThanks for the feedback. and I agree with you, we can add this as a known limitation there too. Currently, we have this on the docs for tables: Tables in data warehousing - Microsoft Fabric | Microsoft Learn

Regards

Geetha

Re: Indexing not supported in Fabric datawarehouse?

duttasoumya — Wed, 12 Jul 2023 12:34:48 GMT

Thank you Anonymous. I just wanted to underline that the example given above has been taken from the official documentation (first link in the post). Perhaps the documentation in that link itself needs an update, aside from adding the limitation.

Re: Indexing not supported in Fabric datawarehouse?

KevinConanMSFT — Wed, 12 Jul 2023 14:35:49 GMT

Greetings duttasoumya! It looks like we have an issue where if you run all the statements you showed at the same time, it will give the error but if you run them one at a time, it works correctly. I'll track that internally to get it resolved, thank you for finding it!

I'll keep track of requests for updating the documentation for possibly adding a note about indexes being a known limitation. Thank you!

Re: Indexing not supported in Fabric datawarehouse?

Anonymous — Wed, 12 Jul 2023 14:55:39 GMT

Thanks, KevinConanMSFT for looking into this.

duttasoumya as Kevin mentioned can you try executing individually and let us know if you have any issues?

Regards

Geetha

Re: Indexing not supported in Fabric datawarehouse?

mikeburek — Tue, 24 Sep 2024 22:03:18 GMT

As a late follow-up, this appears to work correctly now.