...
Navigate to Tools Registry.
Select ‘+ New Tool’ button.
Locate the ‘Flyway Database’ tool and click ‘Select Tool’ button.
Provide values for required fields and any additional info and click ‘Create’ button.
With the new tool, navigate to the Connections tab to configure.
Provide proper credentials to required fields and any additional information, then click ‘Save’ button.
Once saved, click ‘Test Connection’ button to verify connection is successful.
If connection is successful as indicated by button and log, proceed to pipeline setup.
Flyway Pipeline Setup
Navigate to pipelines.
Select ‘+ New Pipeline’ button to create a new pipeline.
Select a template then proceed to Edit Workflow.
In initial Step Setup, set tool as ‘Flyway Database’. Save and click settings cog to reconfigure in Step Configuration:
...
...
Flyway Database: The database(Select the Snowflake ) account configured in the tool registryTool Registry.
SCM Type: Select a Source Control tool → Management type. Choose from Bitbucket, Gitlab…Gitlab and Github.
SCM Account: Select the Source Control Management tool configured in the Tool Registry.
Workspace/Project: Source control Select the Workspace /or Project within your SCM that hosts the repository Repository corresponding to the Snowflake Database.
Repository: Source control Repository that contains Select the Repository within your selected SCM containing the scripts to be migrated.
Branch: Source Control Branch that needs to Chose the branch that will be migrated.
Schema: Schemas Select the schemas that will be managed by flywayFlyway.
Base Schema: Schema The default schema that will host the flyway Flyway schema history table.
Scripts Location: The location within SCM where containing the sql scripts are to be foundSQL scripts.
Database: The Snowflake database where this migration is bound to happenthe migration will occur.
Warehouse: The Snowflake Compute warehouse to be utilized for this operation.