Forum Discussion
arkiboys2
1 year agoHelper IV
fabric datawarehouse
hello, It looks like it is not possible to create keys or index on a table in the warehouse. is this right? the messsage says: primary key or unique keyword is not supported in the create table st...
- 1 year ago
You could use row_number or hashing your rows to get unique values for every row.
FabianSchut
1 year agoSolution Sage
Hi, it is true that it is not possible to create keys or index on a table in the warehouse. Here is the documentation that mentions that limitation: https://learn.microsoft.com/en-us/fabric/data-warehouse/tables#limitations
arkiboys2
1 year agoHelper IV
is there a workaround?
- FabianSchut1 year agoSolution Sage
You could use row_number or hashing your rows to get unique values for every row.