Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Generating Unique Keys in Fabric Data Warehouse

Hi All,   This is my first time posting in a forum. Please apologize me in case if I make some mistakes.   We have a huge dataset, and we are planning to generate unique identifiers in a warehous...
data engineering
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,
    Thank you for your follow-up.


    Seems you are facing duplicate values when generating unique identifiers using NEWID() and GETDATE().
    GETDATE() has limited precision (3 milliseconds), which can lead to duplicate values when multiple rows are inserted in quick succession.

    Instead of GETDATE(), you may use SYSDATETIME() because it has higher precision (up to 7 decimal places for seconds), reducing the chances of duplicates.


    Refer the link for detailed understanding.

    If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

    Thank you for being a part of the Microsoft Fabric Community Forum!


Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your answer and Accept it as solution. It would be greatly appreciated by others in the community who may have the same question

Thank you for being a valued member of the Microsoft Fabric Community Forum!