data // SQLPRODUCTION

Incremental Window with Overlap

Reprocess a small overlap window so late-arriving records are not silently lost.

sqlincrementaletlwatermark

Trust & provenancePRODUCTION

Evidence tierPRODUCTIONOfficial sources0Other sources0Last verifiedNot recorded

Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.

SELECT
    s.*
FROM [Source] s
WHERE s.ModifiedDate >= DATEADD(minute,-15,@LastSuccessfulRun)
  AND s.ModifiedDate <  @CurrentRun

Operational notes

SFMC Query Activities do not support arbitrary SQL variables like @LastSuccessfulRun by themselves; store watermarks in a control DE or generate the window through your orchestration layer.

Use deduplication/upsert logic downstream because overlap intentionally rereads records.