aleksandra_ch
Databricks Employee
Databricks Employee

@Andolina ,

Potential risks of identity columns are:

  • Concurrent writes are not allowed. That is, if multiple flows write to the table with generated identity columns, they will either run sequentially or fail on conflict.
  • There is a slight overhead when inserting values into the table with identity columns.

Yes you can put identity column into the TRACK HISTORY ON parameter.

Best regards,

View solution in original post