Indexing not supported in Fabric datawarehouse?

[duttasoumya]

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

[mikeburek]

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

[duttasoumya]

Thank you @GeethaT-MSFT. 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.

[KevinConanMSFT · Accepted solution]

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!

[GeethaT-MSFT]

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

[GeethaT-MSFT]

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