Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-08-2025 07:53 AM
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