- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How can I generate sequentially increasing row numbers for a table within Fabric Datawarehouse?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ...
Hope this helps. Please let me know if you have any further questions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ...
Hope this helps. Please let me know if you have any further questions.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-10-2024 02:32 AM | |||
11-19-2024 12:53 PM | |||
08-17-2024 08:00 AM | |||
07-07-2023 07:35 AM | |||
07-23-2024 12:53 AM |
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
2 | |
2 | |
2 | |
1 |