Snowflake has become a core part of how many teams store, model, and analyze their data. As more of the business comes to depend on Snowflake, the schema needs the same governance and control as any other production system. Too often, schema change in Snowflake happens through ad hoc scripts, tribal knowledge, or direct access in Snowsight.

We're excited to share that the advanced capabilities SQL Server, Oracle, and PostgreSQL teams already rely on in Redgate Flyway Enterprise are now available for Snowflake. Support for managing Snowflake database objects is now in preview, and we're extending our proven PostgreSQL capabilities to cover Snowflake Postgres too. Whatever combination of platforms your organization runs, you can now manage database changes across all of them with one solution.

Why this matters for Snowflake teams

Teams building on Snowflake run into the same problems that other databases face: several people changing schema at once with no shared record of it, migration scripts written by hand and hoping nothing was missed, and schemas that quietly drift apart between dev, test, and production until a deployment fails. This does not scale, especially as AI assistants are generating even more changes.

Common issues felt by teams are:

• Schema changes made directly against a database, with no record of what changed or why.
• Deployments that fail because production had drifted from what was tested in earlier environments.
• Hours spent working out the difference between two schemas and manually writing migration scripts.

Redgate Flyway Enterprise addresses these across your whole data estate: SQL Server, Oracle, PostgreSQL, MySQL, Databricks, and now Snowflake too.

What are the advanced capabilities

Redgate Flyway Enterprise has supported deploying changes to Snowflake for a while with our foundational capabilities. Now we’re going even further and bringing Snowflake into the same advanced tier already trusted by SQL Server, Oracle, and PostgreSQL teams.

With Redgate Flyway Enterprise advanced capabilities, Snowflake teams can:

1. See and version every schema change, for a clear record of what changed, when, and why
2. Generate versioned and undo migration scripts that account for dependencies automatically, cutting out manual scripting and the errors that come with it
3. Catch problems before they ship, with automated policy checks and clear reports on what a deployment will do
4. Detect drift in any environment and fold it back into the migration process, so what's documented matches what's really there
5. Move faster without trading away safety, because speed and control come from the same workflow

Try out the preview

The capabilities are tested and now available in preview. We want real feedback from real teams before we make them generally available. We're looking for users who:

• Are actively using Snowflake, whether that’s Snowflake databases, Snowflake Postgres, or both
• Want more control over how schema changes are reviewed and deployed
• Need real visibility into what’s actually different across their environments

If that’s you, we'd love to talk with you. Email us for free trial access or book 30-minutes on Zoom to talk through whether the Preview fits your setup.

We're shaping these capabilities around feedback from early users, so now’s the time to get involved. For more details, see our documentation.