Thanks for commenting both!
We're working on adding identity column support for AUTO CDC! As of right now, we recommend adding the surrogate key in the source table before AUTO CDC. You're correct that MERGE INTO itself is atomic, but if a batch is i...
