Fabric Runtime 2.0 is in public preview, and there is one small change for this that makes my life as a data engineer a little bit easier. Identity columns. I miss the good old T-SQL Identity column “Id INT IDENTITY(1,1)”, now we have something like it in Spark/Delta.
So with the the old spark/delta table runtime, you couldn’t have an default, automatically increasing column. But now we have these updates.
Click through to see how it works.