07-14-2022 01:23 PM
How about defining an identity column as below?
GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( [ START WITH start ] [ INCREMENT BY step ] ) ]
https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-create-table-using.html#parameter...
