How to Implement Sequential Primary Keys in Microsoft Fabric Without Sequence or Identity?

Jul '24 (edited) • Technical

I'm working on a project where I need a primary key as a sequentially increasing number, but in Microsoft Fabric, the Sequence and Identity features are not supported. I've tried using NEWID() and converting it to INT, but it's a hash value and won't be sequential.

I found an article where they use MAX and ROW_NUMBER()

LINK:

https://learn.microsoft.com/en-us/fabric/data-warehouse/generate-unique-identifiers

But when I try to parameterize it inside the stored procedure, it's not working.

Is there any other alternative approach?

Note: I don't have much experience in SQL Server and stored procedures.So, pleased to share your thoughts with basic stuff.

6 comments