topic Re: Delta Identity latest value after insert in Data Engineering

Delta Identity latest value after insert

RobsonNLPT — Thu, 05 Sep 2024 10:48:27 GMT

Hi all.

I would like to know if databricks has some feature to retrieve the latest identity column value (always generated) after insert or upserts operations? (dataframe apis and sql)

Database engines as Azure SQL and Oracle have feature that enable latest identities values our sequence values

Any ideas or is there something about on databricks roadmap?

best

Re: Delta Identity latest value after insert

tapash-db — Tue, 03 Dec 2024 16:39:27 GMT

Hi, You can always query "SELECT MAX(identity_column) FROM your_table_name" and see the latest value of the identity column. However, there are no direct functions available to give the latest identity column value.

Re: Delta Identity latest value after insert

RobsonNLPT — Tue, 03 Dec 2024 16:41:50 GMT

Hi.

I was checking for a specific feature to replace that basic approach

Thank you