Hi,
I want to define identity column in the Delta table.
Based on documentation:
"Declaring an identity column on a Delta table disables concurrent transactions. Only use identity columns in use cases where concurrent writes to the target table are not required."
For me this is clear in the situation where I want to write data to the target table from different sessions in the same time but does it concern also situation where I execute MERGE statement to UPSERT/DELETE data from one session only?
I have no idea how MERGE statements works internally.
Maybe it uses concurrent writes but enabling identity column on target table data will be written sequentially.