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