topic Re: How can I generate sequentially increasing row numbers for a table within Fabric Datawarehouse? in Data Warehouse

How can I generate sequentially increasing row numbers for a table within Fabric Datawarehouse?

bexy — Mon, 13 May 2024 22:29:12 GMT

Re: How can I generate sequentially increasing row numbers for a table within Fabric Datawarehouse?

Anonymous — Tue, 14 May 2024 02:49:33 GMT

Hi bexy
Thanks for using Fabric Community.
We can use a work around technique in data warehouses to assign a unique identifier to each row of a table.
I have created the repro:

For more information please refer to this document:
Generate unique identifiers in a warehouse table in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Hope this helps. Please let me know if you have any further questions.

Re: How can I generate sequentially increasing row numbers for a table within Fabric Datawarehouse?

bexy — Tue, 14 May 2024 15:35:41 GMT

Anonymous thanks it is helpful

Re: How can I generate sequentially increasing row numbers for a table within Fabric Datawarehouse?

arpost — Wed, 22 May 2024 17:05:40 GMT

bexy, one thing of which to be aware, though, is this only works if you aren't running multiple scripts that are inserting to the same table. If you have two scripts that insert into the same table around the same time, the workaround risks creating duplicate ID numbers since both scripts would be starting from the same MAX.

There's an idea for people to upvote for Microsoft (upvote link) to add an official identity feature to Fabric so we don't have to use the workaround. The good news is a Microsoft person replied and stated this is planned for 2024, though I haven't seen it on any release plans yet.