Forum Discussion
Advocate IIIndentity and surrogate key
Below link describes the alternatives:
Fabric warehouse is an MPP framework and OLAP (more for analytics purpose)
In case if you want a replicae of SQL server, you can leverage fabric databases rather than fabric warehouse for your use case
Hi Si_7777 you can also use this approach in Fabric Warehouses, which is what I currently use
Generate unique identifiers in a warehouse table - Microsoft Fabric | Microsoft Learn
As NandanHegde said, if you need all the functionality of an RDBMS then Fabric SQL Databases have you covered.
Most Valuable ProfessionalHi Si_7777 you can also use this approach in Fabric Warehouses, which is what I currently use
Generate unique identifiers in a warehouse table - Microsoft Fabric | Microsoft Learn
As NandanHegde said, if you need all the functionality of an RDBMS then Fabric SQL Databases have you covered.