Delta Live Tables: Add sequential column

Costas96
New Contributor III

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!