Flyway
Introduction
Section titled “Introduction”Flyway is an open-source database migration tool that simplifies the process of managing and applying database migrations. Flyway supports various databases, including Snowflake, allowing you to manage database schema changes, version control, and data migration in a structured and automated way.
The Snowflake emulator can connect with Flyway, to apply database migrations, and manage database schema changes locally.
Configuring Flyway
Section titled “Configuring Flyway”In this guide, you will learn how to configure Flyway to interact with the Snowflake emulator.
Install Flyway
Section titled “Install Flyway”You can install Flyway on the official Flyway website. Download the Flyway Desktop & command-line tool and install it on your local machine.
Create a new Flyway project
Section titled “Create a new Flyway project”To create a new Flyway project, follow these steps:
- Open the Desktop application.
- Click New Project.
- Enter the project name and select the database type as Snowflake.
- Click Create project.
Connect Flyway to Snowflake
Section titled “Connect Flyway to Snowflake”To connect Flyway to the Snowflake emulator, follow these steps:
- Click Add target database +.
- Enter username as
test
and password astest
. - Enter JDBC URL as
jdbc:snowflake://http://snowflake.localhost.localstack.cloud:4566/?db=test&schema=PUBLIC&JDBC_QUERY_RESULT_FORMAT=JSON
. - Click on Test connection.
If the connection test succeeds, you can start applying database migrations using Flyway.