Identity property is not working (auto increment)

[malleswariponn]

in fabric warehouse i am trying to create star schema which tables having surrogate key is nothing but identity property  which is not working.i have tried with rownumber also but no luck.can you please suggest are there any approaches which will replace identity property in fabric warehouse

[olivs]

Hi @malleswariponn ,

Is there any way you can provide the CREATE statements that you are using for your tables?

Are you using foreign key constraints? The reason I'm asking is because foreign keys can only be used when NOT ENFORCED is used.

You can find more information about this via the following URL: Tables in data warehousing - Microsoft Fabric | Microsoft Learn

Please let me know if this helps.

If not I suggest that you provide the statements of the objects than I would be more than happy to take a look.

Kind regards,

Olivier

[NandanHegde]

You can use dataflow Gen2 :

https://www.linkedin.com/pulse/overcoming-identity-column-limitations-microsoft-reza-khajavinia-oudz...

to autogenerate new values based on max aspect

[Anonymous]

Hi @malleswariponn 

Creating an identity column in a table isn't supported in a warehouse in Microsoft Fabric currently. Instead, you'll need to use a workaround technique. The following article describes a workaround technique that generates unique identifiers in a warehouse table. Hope you would find it helpful. 

Generate unique identifiers in a warehouse table in Microsoft Fabric - Microsoft Fabric | Microsoft ...

Updated:

According to the messages from the following idea, the support for identity column has been added in the plan. But we haven't received definite ETA for it. Please keep using Fabric and follow the Microsoft Fabric Blog to get the latest updates. 

Microsoft Idea: Add support for identity columns in Fabric warehouses.

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[malleswariponn]

I have tried but no luck with unique identifier.can you please provide alternative solution