Delta Identity latest value after insert

[RobsonNLPT]

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

[tapash-db]

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.

[RobsonNLPT]

Hi.

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

Thank you