Delta Live Tables: Add sequential column

Costas96 — Fri, 17 Jan 2025 09:28:59 GMT

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!

Re: Delta Live Tables: Add sequential column

Alberto_Umana — Fri, 17 Jan 2025 13:06:29 GMT

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-available-in-a-lakehouse-near-you.html

topic Re: Delta Live Tables: Add sequential column in Data Engineering

Delta Live Tables: Add sequential column

Re: Delta Live Tables: Add sequential column