Tinybird is launching a beta for lightweight deletes on Data Sources via a new API endpoint (`POST /v1/datasources/{name}/delete`). Unlike the old heavy mutation approach that rewrites disk parts, the new method uses ClickHouse's native lightweight DELETE, which materializes a hidden `_row_exists` mask instead of copying data. This makes deletes complete in milliseconds to seconds rather than minutes or hours. The endpoint supports both synchronous and asynchronous modes, an optional partition-scoping parameter, and is useful for GDPR right-to-be-forgotten requests, removing bad ingest data, and partition-scoped cleanups.

4m read timeFrom tinybird.co
Post cover image
Table of contents
How Tinybird deletes used to workA new lightweight delete insteadSync or async, your callWhen does it come handyTry it
5.1K Impressions