Help · section 33 of 44
Change Tracking
Mirrors the in-app Help. The live copy in your console and `dlake guide help` are always current.
SQL Server change tracking for sync consumers: enable per table, then GET /api/ddl/change-tracking/tables/{table}/changes?fromVersion=N returns inserted/updated/deleted row keys since that version (/version gives the current watermark). Requires data.read, and honors a scope-restricted key’s per-entity read grant (a field-restricted key gets only its granted columns in each change’s row image). Ideal for incremental pull sync; pair with Events for push. A scoped key’s changes read is additionally enforced in the database under the key’s own principal — fail-closed, never falling back to weaker enforcement.