Delta Live Tables: Add sequential column

[Costas96]

Hello everyone, I have a DLT table (examp_table) and I want to add a sequential column that its values will be incremented every time a record gets ingested. I tried to do that with monotonically_increasing_id and 

Window.orderBy("a column") functions but ofc this actions are not allowed at a DLT table. Is there a suggested workaround for such cases ? Any suggestion would be appreciated. Thanks!

[Alberto_Umana · Accepted solution]

Hi @Costas96,

Thanks for your question. You can use identity column feature.

https://www.databricks.com/blog/2022/08/08/identity-columns-to-generate-surrogate-keys-are-now-avail...