I’m trying to migrate DB objects(tables, views, procedures, etc) from dev to other regions using flyway. I’m currently using flyway 10.15.2 version and trying to connect to snowflake via key pair authentication(public & pvt key). Below is my flyway.conf file and i’m getting the below error while running ‘flyway -X info’
flyway.url=jdbc:snowflake://xb44352.eu-west-1.snowflakecomputing.com/?db=ENT_MDM_RAW&warehouse=EDP_ENT_MDM_ANALYTICS_WH
[email protected]
flyway.warehouse=EDP_ENT_MDM_ANALYTICS_WH
flyway.role=EDP_EDP_ENT_MDM_ANALYST_DEV
flyway.jdbcProperties.private_key_file=Userskxxs361rsa_key.p8
C:flywayflyway-10.15.2>flyway -X info
DEBUG: Java Version: 17.0.11+9
DEBUG: Loading config file: C:flywayflyway-10.15.2confflyway.conf
DEBUG: Loading config file: C:Userskxxs361flyway.conf
DEBUG: Unable to load config file: C:flywayflyway-10.15.2flyway.conf
DEBUG: Using configuration:
DEBUG: [environments.sample] ->
[flyway] ->
flyway.jdbcProperties.db -> ENT_MDM_RAW
flyway.jdbcProperties.jdbc_query_result_format -> json
flyway.jdbcProperties.private_key_file -> Userskxxs361rsa_key.p8
flyway.jdbcProperties.role -> EDP_EDP_ENT_MDM_ANALYST_DEV
flyway.jdbcProperties.warehouse -> EDP_ENT_MDM_ANALYTICS_WH
flyway.locations -> filesystem:C:flywayflyway-10.15.2sql
flyway.role -> EDP_EDP_ENT_MDM_ANALYST_DEV
flyway.url -> jdbc://app.eu-west-1.privatelink.snowflakecomputing.com/
flyway.user -> [email protected]
flyway.warehouse -> EDP_ENT_MDM_ANALYTICS_WH
ERROR: Unexpected error
org.flywaydb.core.api.FlywayException: No database found to handle jdbc://app.eu-west-1.privatelink.snowflakecomputing.com/
at org.flywaydb.core.internal.jdbc.DriverDataSource.<init>(DriverDataSource.java:926)
at org.flywaydb.core.internal.jdbc.DriverDataSource.<init>(DriverDataSource.java:864)
at org.flywaydb.core.api.configuration.ClassicConfiguration.getDataSource(ClassicConfiguration.java:890)
at org.flywaydb.core.api.configuration.ClassicConfiguration.configure(ClassicConfiguration.java:2487)
at org.flywaydb.core.api.configuration.FluentConfiguration.configuration(FluentConfiguration.java:1671)
at org.flywaydb.commandline.configuration.LegacyConfigurationManager.getConfiguration(LegacyConfigurationManager.java:851)
at org.flywaydb.commandline.configuration.ConfigurationManagerImpl.getConfiguration(ConfigurationManagerImpl.java:811)
at org.flywaydb.commandline.Main.main(Main.java:874)
flyway.jdbcProperties.private_key_file=Userskxxs361rsa_key.p8