Most schema changes don't need a full table rebuild. We added ALTER TABLE support to Tinybird deployments so simple changes deploy in seconds, not minutes.

Tinybird is a real-time data analytics platform for building fast and scalable data pipelines, offering tools for data ingestion, processing, and visualization. From this blog users can learn about stream processing, data warehousing, and analytics techniques to unlock insights from their data and make data-driven decisions.

Tinybird

Tinybird has shipped ALTER TABLE support in its deployment engine, replacing the previous brute-force approach of full table rebuilds for every schema change. Previously, even simple operations like adding a column triggered a create-backfill-swap cycle that could take minutes on large tables. Now, the deployment engine classifies each change into four categories (NoChange, MetadataOnly, AlterOperation, Schema) and applies in-place ALTER TABLE statements for supported operations: TTL changes, column additions/drops, nullable modifications, default value changes, and index changes. A deploy that previously took minutes on a 200GB table now completes in under 5 seconds. The system includes safety checks for pending mutations, column droppability, and downstream impact, plus rollback query generation. Materialized Views also gain a DEPLOYMENT_METHOD 'alter' directive to apply query changes via ALTER TABLE MODIFY QUERY instead of full recreation.

Smarter deployments in Tinybird: faster schema changes for the most common operations