Forum Discussion
arkiboys2
Helper IV
Helper IVfabric 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...
You could use row_number or hashing your rows to get unique values for every row.
FabianSchut
Solution Sage
Solution SageHi, 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
arkiboys2is there a workaround?
- FabianSchut
You could use row_number or hashing your rows to get unique values for every row.