Forum Discussion
Adding auto incremented identity column to deltalake table
Yes i am using Notebooks to Upserts / merge
And i already solved it by similar approach, just forgot to tell here.
My current solution was that i added the monotonically_increasing_id column to the delta tables at the bronze layer and added the current date of the data load for uniqiness of values then they update the silver delta tables like any other table with consistent schema between the two delta tables
Hi UsefGamal
Thanks for using Fabric Community.
Currently we cannot create new tables using SQL endpoint of the lakehouse. But you can create unique identifiers in Warehouse tables:
Generate unique identifiers in a warehouse table in Microsoft Fabric - Microsoft Fabric | Microsoft Learn
If you need this table in Lakehouse, you can create a shortcut to this table in the desired lakehouse.
Hope this helps. Please let me know if you have any further questions.
Hi UsefGamal
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks
Hi @UsefGamal
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks