Name of the per-record content-hash mirror column. Written on every integration
table alongside the other __mj_integration_* columns when present. Holds the
SHA-256 (hex) of the last-synced external field values.
This is the change-detection lever for connectors that have NO usable watermark
(the source can't tell us "what changed since T"), e.g. YourMembership: every
sync re-fetches every record. Comparing the freshly-computed hash of an incoming
record against the stored hash lets the engine skip the per-record DB load and
write entirely for the unchanged majority — turning a 50k-record no-op re-sync
from 50k loads into ~0.
Gated everywhere by EntityInfo field presence, so it is a no-op on tables that
predate the column (the engine still syncs correctly via the dirty-flag path).
Name of the per-record content-hash mirror column. Written on every integration table alongside the other
__mj_integration_*columns when present. Holds the SHA-256 (hex) of the last-synced external field values.This is the change-detection lever for connectors that have NO usable watermark (the source can't tell us "what changed since T"), e.g. YourMembership: every sync re-fetches every record. Comparing the freshly-computed hash of an incoming record against the stored hash lets the engine skip the per-record DB load and write entirely for the unchanged majority — turning a 50k-record no-op re-sync from 50k loads into ~0.
Gated everywhere by EntityInfo field presence, so it is a no-op on tables that predate the column (the engine still syncs correctly via the dirty-flag path).