The Wire · Showcase
CLICKHOUSE SCHEMA CORRUPTION FIX LANDS ACROSS ETL STACK
By RepoJournal · Filed · About Supabase
Supabase shipped a critical fix that prevents ClickHouse from destroying newer columns during CDC replay restarts, then propagated the same safety logic across Pulumi and Terraform tooling.
The ETL team closed a data loss vulnerability where replayed relation events with stale schema snapshots drove backwards DDL, dropping columns that had been added since the last snapshot [1]. This is a guard rail every data pipeline operator needs: reject any snapshot older than what's already applied, and tell the operator exactly what happened [3]. The fix shipped alongside BigQuery client updates [2] and error message improvements [4] to make recovery paths clearer when schema mismatches occur. Across infrastructure tooling, a coordinated wave landed Apache 2.0 license alignment [9], [10], [13], and a systematic propagation of tag prefix handling into actual measurement tags rather than just description prefixes [8], [11], [14], [15]. The terraform-provider-ripe-atlas shipped v0.1.3 [12] with all these fixes baked in. On the docs and platform side, FGA permissions now read from the proper OpenAPI extension field [5], vulnerable dependencies got bumped [6], and broken local links in documentation went through systematic repair [7].
One email a day. Unsubscribe in one click.
What actually shipped in Supabase, written up every day — commits, pull requests, releases, and security advisories.
One email a day. Unsubscribe in one click. Read a past issue →
Action items
- → Review ClickHouse CDC deployments for any pending restarts - apply the schema rewind fix before triggering recovery supabase/etl [immediate]
- → Upgrade terraform-provider-ripe-atlas to v0.1.3 if you use measurement tagging in infrastructure code supabase/terraform-provider-ripe-atlas [plan]
- → Pull the dependency bump into your deployment pipeline - multiple CVEs addressed supabase/supabase [plan]
References
- [1] clickhouse: Prevent unsafe schema rewind during CDC replay ↗ supabase/etl
- [2] feat(bigquery): Use updated BigQuery client ↗ supabase/etl
- [3] clickhouse: Prevent unsafe schema rewind during CDC replay (#925) supabase/etl
- [4] fix(clickhouse): Reword recovery snapshot error (#928) supabase/etl
- [5] fix: read FGA permissions from openapi spec x-fga-permissions extension (#48181) supabase/supabase
- [6] chore: Bump vulnerable deps (#48178) supabase/supabase
- [7] fix(docs) Fix local broken links (#48212) supabase/supabase
- [8] feat: add tagPrefix to measurement as a tag (#6) supabase/pulumi-atlas
- [9] fix: change to apache 2.0 license (#7) supabase/pulumi-atlas
- [10] fix: appropriate license ↗ supabase/terraform-provider-ripe-atlas
- [11] feat: plumb tag_prefix through to measurement tags (#9) supabase/terraform-provider-ripe-atlas
- [12] v0.1.3 ↗ supabase/terraform-provider-ripe-atlas
- [13] fix: switch to Apache 2.0 ↗ supabase/atlasctl
- [14] fix: tag -> namespace (#30) supabase/atlasctl
- [15] fix: store the tag prefix as a tag itself (#28) supabase/atlasctl