The new Copy Job in Fabric is great. It lets you configure DELTA loads if you can specify the "Incremental column" for a table. BUT, the only data types it will accept are INT (and I assume BIG | SMALL, etc) and Date/Time.
What about ROWVERSION? In my opinion, this is the ABSOLUTE BEST data type for tracking incremental changes. Consider this: Any other type must be managed by the programming layer, either the application or a trigger. And, what happens if some other process breaks in and UPDATES those columns between runs? You will be in an inconsistent state.
ROWVERSION data type columns are, by definition: A) Managed by SQL (populated and updated automatically), B) immutable (they cannot be changed via an UPDATE statement like other columns.
Please add support for selecting ROWVERSION type columns (from SQL Server) to the CopyJob activity.
... View more