Improved DDL Support for Cell-Based Architectures
A new opt-in job checks and syncs table schemas across environments, adding new columns even when a database has no row changes.
In environments with multiple isolated databases - like production, staging, and dev - schema drift is a persistent risk. Columns added in one cell might not appear in another unless there’s active data flowing through. That means teams looking at the “same” table in Snowflake could be seeing different structures, leading to confusion, bugs, and broken dashboards.
This became especially painful for teams whose QA and Dev environments receive little to no traffic. With our previous behavior, tables wouldn’t update unless a row changed - leaving environments out of sync.
Artie now supports schema alignment across environments.
We’ve introduced a new opt-in job that automatically checks and syncs table schemas across environments - even when there are no row changes. If a new column shows up in production, it’ll get added to dev and staging too, so all environments stay aligned.
This feature ensures you get consistent schemas, no matter how much (or little) traffic a database gets.
Why this matters
- Guarantees column consistency across environments (prod, staging, dev)
- Eliminates silent schema drift in low-traffic databases
- Supports cell-based and single-tenant architectures out of the box
- Reduces debugging time and improves trust in test environments