Redgate Flyway

EDITION: ENTERPRISE

We are currently working on Flyway's advanced capabilities for Snowflake, which will let you compare, govern, and deploy schema changes for Snowflake using the same state and migrations workflows you already use for other database types. It connects to Snowflake over JDBC and works with Snowflake Data Warehouse and Snowflake Postgres.

Get in touch with our Development Team to learn more.

Advanced capabilities include

Understanding changes made to a development schema
Scripting those changes out so each object can be versioned controlled giving you an object-level history to see who, changed what, when and why
Optionally generating versioned and undo migrations scripts, which account for dependencies
Reporting on changes as part of your CI/CD pipeline so you can understand how many objects will be touched at a glance and drill into more details with a side-by-side diff of the changes
Check for drift to ensure environments reflect what is in version control to catch issues sooner before releasing to production

Coming soon

Get in touch with our Development Team to learn more.

Create a new project in Flyway Desktop and select PostgreSQL as the database type
On the Schema model page, click Start here to link your development database
1. Copy your Host name from your Snowflake Postgres account:
Use this as your Host, enter your Database, Schemas, Username and Password information in the connection dialog:
Click Continue and optionally specify Filters and Static data, before clicking Finish.
The initial state of your schema objects have now been saved to disk.
Click Show details for more information.
Clicking Close and Continue returns you to the Schema model page. You can see the current state of all the objects in the Schema Model by clicking on them in the right for details
Now, start making changes directly to your development database. Refresh the Flyway Desktop Schema Model to see your changes and save them to disk when you're ready.

Next steps

Learn more about automating your Snowflake deployments safely as part of your CI/CD processes

Turning the Datawarehouse Preview off - Coming soon

Advanced Snowflake support is on by default. To turn it off:

Flyway Desktop: go to Settings > Preview features and turn the Snowflake option off.

Giving feedback

We'd love to hear how you get on with the Preview. Tell us what works, what doesn't, and what you'd like to see next.

Please complete our quick survey or email us with your feedback.