pdiamond
Contributor

If you recreate the table using BIGINT GENERATED BY DEFAULT  instead of BIGINT GENERATED ALWAYS you can manipulate the column values.

"When using the clause GENERATED BY DEFAULT AS IDENTITY, insert operations can specify values for the identity column."

https://docs.databricks.com/aws/en/delta/generated-columns#use-identity-columns-in-delta-lake