Unlock this content
Enter your email to unlock this content for free
APPEND vs REPLACE Mode
TL;DR
Tinybird provides two primary modes for writing data: append (incremental updates) and replace (complete replacement). Use append for continuous data ingestion and replace for snapshot-style updates. Both modes are available in Copy Pipes and the Data Sources API, with replace also supporting conditional replacement for specific partitions.
Understanding when to use append versus replace mode is crucial for managing data ingestion and updates in ClickHouse. Each mode serves different use cases and has different implications for data consistency, performance, and storage.
Understanding the Two Modes
Loading diagram...