org.flywaydb:flyway-database-databricks

See release notes here

Bug fixes

• Fixed a bug where Redshift CREATE, ALTER and DROP IDENTITY PROVIDER statements were run inside a migration transaction, which Redshift does not support

Java compatibility

• ConfigurationExtension.copy() no longer requires jackson-databind on the classpath; if it's absent, copy() falls back to a shallow copy

Internal dependency

• Upgraded RgCompare to 1.62.6.5172

See release notes here

Breaking changes

• JSON results with timestamps now include a UTC offset. Reports generated will not be compatible with previous versions of Flyway. API users relying on getTimestamp or setTimestamp will need to use OffsetDateTime instead

Changes

• Flyway now warns when validate resolves no migrations from the configured locations but the schema history contains applied migrations

• mcp server project load will no longer raise an error if a .conf project was detected in a default location outside of the project root

• OSS no longer recognises the 'publishResult' or 'checkDriftOnMigrate' parameters which had no effect

Bug fixes

• Configuration details defined against a specific environment, such as a custom schema history table or default schema, were lost when Flyway switched to that environment

• The Docker provisioner could not connect to Oracle 23 and later containers, failing with ORA-12514, because it requested the wrong pluggable database service

Java compatibility

• CockroachDB is now provided as a standalone database module. API users targeting CockroachDB should include the new CockroachDB module instead of relying on the PostgreSQL module

Library upgrades

• Upgraded adoptium/temurin25-binaries from 25.0.3+9 to 25.0.4+7

• Updated BouncyCastle to 1.85 to address a High severity Uncontrolled Recursion advisory

• Updated Oracle SQLcl in the Flyway Docker oracle image to 26.2.0.181.2110, resolving CVE-2026-68494 in jackson-core

See release notes here

New features

• deploy command result now includes execution time in milliseconds

• environments_<name><setting> and flyway<setting> environment variables can now use any letter casing in their prefix, e.g. ENVIRONMENTS_PRODUCTION_PASSWORD

Database compatibility

• Databricks Lakebase is now recognised as a supported PostgreSQL-derivative database type in public preview

• snapshot history is now supported on Databricks

Bug fixes

• Databricks identifiers containing a backtick produced invalid SQL

• Databricks migrations could fail at the unlock step with a Delta ConcurrentAppendException; the lock keepalive no longer races the unlock

• Issue 4259 Fixed afterConnect callback not being fired on the migration connection

• Fixed an issue that prevented several after*OperationFinish SQL callback scripts (clean, validate, undo, repair, baseline) from ever running

• Fixed an issue where the Docker provisioner for Oracle would immediately exit

• Fixed dry run failing on Databricks with "Unable to switch connection to read-only" error

Java compatibility

• Issue 4240 Log execution of Java callbacks, matching SQL/script callback logging

Library upgrades

• Upgraded jansi to use org.jline.jansi package

See release notes here

New features

• Add support for new 'IncludeOnlineIndexCreation' option for Oracle

• check drift and check changes JSON output now includes an id for each difference, allowing drift to be resolved against specific objects

• Flyway MCP server now available, exposing development-time tools an AI agent can call. These tools run flyway commands for both state based and migrations projects

Changes

• Include the offending SQL in error messages for Flyway Desktop when debug logging is disabled

• the docker provisioner now reports a dedicated error code when a SQL Server or Oracle container is provisioned without accepting the database vendor's EULA

Bug fixes

• Fixed the 'auth' command incorrectly showing a "no locations configured" warning that only applies to migration commands

Library upgrades

• Updated jackson-databind to 3.1.5 / 2.22.1 to address a High-severity Incorrect Authorization advisory

See release notes here

New features

• Add support for new 'disable-constraints-for-static-data' option for PostgreSQL

Changes

• -h help for migrate, info, validate, clean, and undo now lists relevant configuration parameters and a usage example instead of just a description

• Oracle SQL error output no longer shows the redundant SQL State and Error Code lines, as the ORA-#### code is already in the message

• testConnection now keeps the configured environments available so provisioners that reference another environment (for example the docker provisioner's sourceEnvironment) resolve correctly when testing an inline environment

• testConnection now reports provisioning progress (e.g. Docker container start-up) when progress output is enabled

• the docker provisioner now reports clear, dedicated errors when the Docker CLI is not installed or the Docker daemon is not running

• the legacy compose-file configuration of the preview docker provisioner is deprecated and now logs a warning; use the docker-compose provisioner instead

• using 'auth' without the '-IAgreeToTheEula' flag defaults to an interactive EULA agreement process

Bug fixes

• Fixed an issue where authentication warnings could be displayed multiple times during a Flyway run

• Issue 4253 Fixed FlywayUnknownMigrationTypeException when schema history table contains legacy SPRING_JDBC type from older Flyway versions

Performance improvements

• Improved Flyway CLI cold start time by switching driver JARs from eager static classpath loading to lazy dynamic loading

Library upgrades

• Upgrade Snowflake from 4.0.2 to 4.3.1

See release notes here

New features

• smart docker provisioner keepAlive reuses the build database container across Flyway commands

Changes

• filesystem location 'not found' messages now report the effective working directory and prompt you to check it, since running Flyway from the wrong working directory (without -workingDirectory) is a common cause

• Native Connectors mode is now enabled by default for Cassandra

• outOfOrder mode is now reported at info level instead of as a warning

• The preview docker environment provisioner has been renamed to docker-compose. Existing docker provisioner configurations that use a compose file continue to work via automatic forwarding.

Bug fixes

• A missing callback location (including the default filesystem:callbacks) is now skipped instead of being logged as an error or failing the command

• drift resolution script generation failures no longer fail the check drift command; drift is still reported and any scripts that can be generated are still written

• Fixed drift resolution failing to generate scripts when the drift included object types whose names contain spaces (e.g. user-defined types)

• The smart docker provisioner now starts Postgres and MySQL build containers with valid credentials and a usable default schema, so provisioning and migrating against them succeeds

Performance improvements

• skip building an unused Flyway instance for configuration-only commands (e.g. constructMigrationName, parseMigrationName, comparison-capabilities), reducing their startup latency

Library upgrades

• Upgraded com.fasterxml.jackson.core:jackson-databind from 2.21.2 to 2.22.0

• Upgraded tools.jackson.core:jackson-databind from 3.1.1 to 3.1.4

See release notes here

New features

• Added a check.driftResolutionFolder setting to configure the folder in which drift resolution scripts are generated when drift is detected

• Flyway CLI now exits with a distinct exit code derived from the error code when a FlywayException is thrown

Changes

• check drift, changes and dryrun commands now report phase-level progress when outputProgress is enabled

See release notes here

Bug fixes

• Fix FLYWAY_TOKEN and FLYWAY_EMAIL environment variables not being recognised for PAT authentication

See release notes here

Changes

• Flyway now warns when an offline permit is due to expire within the next 30 days

• Improved progress reporting for PostgreSQL, MySQL and SQLite

Bug fixes

• Oracle EXEC statements preceded by a comment now parse correctly

Java compatibility

• API users now must include a flyway Licensing module dependency to be recognized as Redgate edition

See release notes here

New features

• Flyway can load custom SQLFluff rules for use in the Check command

Java compatibility

• API users are now required to include the flyway-proprietary module to use Redgate proprietary features

Internal dependency

• Upgraded RgCompare to 1.58.2.4353

New features

• Environment Variable resolver syntax now works in all flyway configuration parameters, not just environment connection properties

Database compatibility

• Issue 4238 Cockroach v26 is now supported

Bug fixes

• fix crash in check code when SQLFluff emits LXR violations for files containing a UTF-8 BOM

• Fixed misleading "try running the 'auth' command" warning appearing when already running auth command

Library upgrades

• Upgraded ch.qos.logback:logback-classic from 1.2.3 to 1.2.13

• Upgraded org.apache.derby:derby from 10.16.1.1 to 10.17.1.0

• Upgraded org.apache.logging.log4j:log4j-core from 2.17.1 to 2.25.4

Internal dependency

• Upgraded RgCompare to 1.58.1.4262

Bug fixes

• flyway repair against a dry-run target no longer fails for SQL baseline migrations

• license text files now included in Flyway distributions

New features

• Flyway now supports Native Connectors mode for the Deploy command

Changes

• Auth command now defers to existing license providers instead of redundantly re-authenticating. License output now reports the acquisition method.

• configuration errors caused solely by obsolete parameters now throw ObsoleteConfigurationParametersException, exposing the obsolete parameters as structured data

• Issue 4229 Gradle plugin is now compatible with Gradle's configuration cache for environment variable and system property inputs

• obsolete parameter exception payload now includes a reason field explaining why each parameter is obsolete

• simplified namespace short-circuiting (aka scoped namespacing) so that mixing scoped and unscoped namespaces is allowed

Database compatibility

• Issue 4232 Add support for DROP ... IF EXISTS and CREATE ... IF NOT EXISTS for Oracle parser

Bug fixes

• Issue 4230 Only create synonyms for Oracle SHTs when the name includes lower case characters

Library upgrades

• Upgraded adoptium/temurin25-binaries from 25.0.2+10 to 25.0.3+9

• Upgraded com.google.jimfs:jimfs from 1.3.0 to 1.3.1

• Upgraded org.apache.maven.plugins:maven-antrun-plugin from 1.7 to 1.8

• Upgraded org.apache.maven.plugins:maven-compiler-plugin from 2.3.2 to 3.15.0

• Upgraded org.apache.maven.plugins:maven-deploy-plugin from 3.0.0-M1 to 3.1.4

• Upgraded org.apache.maven.plugins:maven-failsafe-plugin from 3.1.0 to 3.5.5

• Upgraded org.apache.maven.plugins:maven-install-plugin from 3.0.0-M1 to 3.1.4

• Upgraded org.apache.maven.plugins:maven-jar-plugin from 3.0.2 to 3.5.0

• Upgraded org.apache.maven.plugins:maven-resources-plugin from 2.5 to 3.5.0

• Upgraded org.apache.maven.plugins:maven-surefire-plugin from 3.1.0 to 3.5.5

• Upgraded org.apache.maven.wagon:wagon-http from 2.12 to 3.5.3

• Upgraded org.codehaus.mojo:versions-maven-plugin from 2.7 to 2.21.0

• Upgraded org.junit.jupiter:junit-jupiter from 6.0.1 to 6.0.3

• Upgraded org.junit.platform:junit-platform-launcher from 6.0.1 to 6.0.3

• Upgraded org.mockito:mockito-core from 5.18.0 to 5.23.0

• Upgraded org.mockito:mockito-junit-jupiter from 5.18.0 to 5.23.0

• Bumped aws-secretsmanager-jdbc from 2.0.4 to 2.1.0

Internal dependency

• Upgraded RgCompare.Cli from 1.55.1.3732 to 1.56.1.3818

New features

• Flyway now supports Azure Key Vault as a secrets resolver

• Flyway now supports Native Connectors mode for Cassandra. The JDBC-based approach has been deprecated

Changes

• flyway prepare with -prepare.source=schemaModel now fails with a clear error when the configured schema model directory does not exist

• "initSql" has been deprecated. Please use the "afterConnect" callback instead

• The Flyway Secret Manager feature is no longer available under Teams license

Bug fixes

• Fix pluginConfigurations in the Maven and Gradle plugins not being handled by Flyway

• Retry Informix table drops on ISAM file lock errors

Internal dependency

• Upgraded RgCompare.Cli from 1.52.6.3589 to 1.55.1.3732

Breaking changes

• (Preview) the preview verb 'diffApply' has been replaced with the verb 'model'

Bug fixes

• Fix error message when using unpopulated default placeholders with configured seperators

• Fixed an issue where the 'Placeholders' configuration erased the 'jdbcProperties' configuration

• Resolved issue where Flyway would fail to publish an event to Flyway Pipelines using a PAT token in conjunction with using an offline permit for licensing

Changes

• collations will now be dropped on postgres

• MySQL schema history table will create using default storage engine instead of being forced to InnoDB

• addTimestamp boolean option for generate and add verbs has been replaced with timestamp=always|auto|never option

New features

• Scoped Namespaces: when configuring on the command line, you can skip namespaces if they match the verb of which you are in the scope of. For example, rather than flyway init -init.projectName=test you can now shortcut to flyway init -projectName=test.

Thanks to Mihitoko and kantselovich for reporting these issues.

Breaking changes

• Removedcheck.url, check.password and check.username. These undocumented historic fields have been deprecated for a while and have confusing impacts (such as not working in all check functionality). It is recommended to use environments to replace this functionality, alternatively, check does support standard url, username and password

Bug fixes

• Fixed an issue that the Repair command was unable to remove failed Repeatable migration entries in schema history table for MongoDB

Changes

• Backup provisioner now puts database into single user mode before restoring

• Legacy Flyway keys (FL0...) are now deprecated

Java compatibility

• Update H2 2.3.224 to 2.3.232

• Upgrade snowflake-jdbc 3.14.3 to 3.20.0 to fix CVE-2024-43382

Performance improvements

• Improved repair performance when removing failed migrations

Bug fixes

• Fix a bug where error messages are produced when check -drift is run without setting deployedSnapshot

• FLYWAY_PIPELINE_ID environment variable was previously broken but is now fixed

Changes

• The 'createSchema' callback is now deprecated and replaced by 'beforeCreateSchema'

Database compatibility

• Support PostgreSQL 17

Java compatibility

• jetty-server 9.4.53.v20231009 to 9.4.56.v20240826 to fix CVE-2024-8184

Thanks to cowwoc for reporting these issues.

Bug fixes

• Issue 3915 Fixed an issue that could cause Flyway to hang when a database connection is unavailable and there are a large number of pending migrations

Changes

• cleanOnValidationError is now deprecated

Database compatibility

• Updated snowflake driver to 3.14.3

New features

• Flyway now supports setting personal access token (PAT) through API

• Added a warning message if 'group' parameter is enabled for databases which don't support DDL transactions

Thanks to Quairix for reporting these issues.

Bug fixes

• Fixed the bug that prevented powershell scripts from running when located in a folder with spaces in the folder name.

• Fixed the issue where schemas might get inadvertently cleaned when running check in MySQL

Database compatibility

• Cassandra taken out of preview and added to OSS edition

New features

• Azure Identity is now a dependency of Flyway for SQL Server Active Directory MSI authentication

• Flyway now supports Environment Overrides for parameters configuration

Bug fixes

• Fix a bug where mongoDb database name was null

• Removed duplicate libraries from the command line

• Issue with ${flyway:workingDirectory} not using configured working directory has been fixed

• Fixed an issue where failed migrations could report a negative execution time

Changes

• The schema model's location is now also specified in schemaModelLocation in the Flyway namespace in Flyway.toml

Bug fixes

• Fixed bug where certain keywords in BigQuery and HSQL were not handled correctly when in lower case.

• Fix a bug where targetSchemaVersion is not set in API and JSON result objects when migrate fails, or no versioned migrations are applied

• Fix the bug preventing users from initiating a trial using the "auth" command

Database compatibility

• Issue 3900 Increase Cloud Spanner support to 2.18.1

• Issue 3905 Increase H2 support to 2.2.224

Java compatibility

• add file helpers

Thanks to credmond-git and BlueIce for reporting these issues.

Bug fixes

• Flyway shouldn't call SqlFluff if there are no pending migrations found

Changes

• Reworded exception messages when executing scripts fails to say "Script ... failed" instead of "Migration ... failed"

• 'beforeEachMigrateStatement' and 'afterEachMigrateStatement' callbacks are now open source features

• Updated wording on Drift Report

New features

• Personal Access Tokens are now supported as a method of authorizing Flyway

• 'versioned' and 'repeatable' can now be used for 'ignoreMigrationPatterns' in the open-source version.