← SQL CopilotCONTENT HISTORY
WHAT CHANGED
Update to SQL Copilot
Snapshot Nov 4, 2026 · 00:11 UTC · version 0.2.0
Collection source: downloaded plugin package.
First saved snapshot
No earlier snapshot is available to establish a change.
Save SQL Copilot and check future changes in Following.
Up to 10 plugins free · no card required.
Compare saved observations
Download comparison JSONFull technical diff · 0 changed fields
Full snapshot data
{
"description": "Design reliable incremental loads, dedup, watermarks, CDC and merge/upsert logic.",
"included_files": [],
"name": "incremental-cdc-merge",
"skill_md_contents": "---\nname: incremental-cdc-merge\ndescription: Design reliable incremental loads, dedup, watermarks, CDC and merge/upsert logic.\n---\n\n# Incremental Cdc Merge\n\n**Trigger:** Design reliable incremental loads, dedup, watermarks, CDC and merge/upsert logic.\n\n## Workflow\n1. State source and target grains; document business key, version/order, event time, load time, late-data window, deletes and replay requirements.\n2. Identify duplicate source records, out-of-order events, missing tombstones and boundaries before selecting a MERGE or incremental strategy.\n3. Separate source preparation/dedup from target mutation; enforce one deterministic record per target key where required.\n4. Define idempotency with repeated or overlapping runs and high-water marks inclusive/exclusive handling.\n5. Create reconciliation checks for inserted, updated, deleted, skipped and late records and safe backfill/rollback planning.\n\n## Critical standard\nNever delete checkpoints or replay an entire production source as a convenience; protect state and authorization.\n\n## Evidence and execution\nOnly say \"executed\", \"passed\", \"observed\", \"optimized\" or \"deployed\" when a connected tool returned evidence for that claim. An SQL draft, a textual review, or local fixture proof alone is not production validation. Never ask the user to paste passwords or raw confidential records.\n\n## Supporting references\n- Read `../../references/incremental-and-cdc.md` when relevant.\n- Read `../../references/safe-write-checklist.md` when relevant.\n- Read `../../references/windows-and-dedup.md` when relevant.\n\n## Return\nIncremental contract, data-flow steps, pseudocode/SQL and replay tests.\n"
}SHA-256 of public snapshot: 77bad09a8b1a1ed8d42f4c0c018db2ea38bd7841b7202c14dae544746e77aa24