Append
write_mode=append. Without a policy (legacy) it's dumb — a blind physical append. In the wizard, the default policy is soft_refresh (date-aware), not dumb.
Policies
| Policy | Behavior |
|---|---|
soft_refresh | last−1…today, refreshes the tail |
rewrite_from_last | last…today, delete+rewrite |
dumb | full range, physical append (duplicates possible; schedule OK) |
Diagrams: write-modes, soft-refresh.
When to use it
- Need history on the sheet plus a daily tail → soft_refresh
- Need a blind log → dumb
- Need deduplication by key → use
append_dedup, not append