Liquibase 4.33.0 is a minor release

Liquibase 4.33.0 delivers important updates across Policy Checks, Change Automation, and other areas of platform enhancement, along with critical bug fixes and improvements to MongoDB, PostgreSQL, and DB2 on Z/OS support. See the Liquibase 4.33.0 Release Notes for the complete set of release information.

Notable Changes

[PRO]

Change Automation

• PostgreSQL Composite TYPE Support in Database Inspection. Liquibase Pro now includes support for inspecting PostgreSQL Composite TYPE objects during database inspection operations such as snapshot and diff. This enhancement ensures Composite TYPEs appear in inspection outputs, helping users manage and track changes to complex data structures more effectively. [INT-1249] [INT-135]

• PostgreSQL Composite TYPE Support in generate-changelog and diff-changelog. Liquibase Pro now includes support for detecting PostgreSQL composite TYPE objects during generate-changelog and diff-changelog operations. This enhancement ensures that composite TYPE definitions—used to group multiple fields into a custom data structure—are captured and modeled alongside other schema elements, helping users manage and track changes more comprehensively. [INT-1251]

• PostgreSQL Password Escaping Enhancement. Liquibase now escapes special characters in PostgreSQL passwords when using the psql native executor. Previously, if a password included characters requiring percent-encoding (such as @, %, or #), the executor would fail with a psql: error: invalid percent-encoded token message. [DAT-20254]

• Db2 on Z/OS JCL Executor. Liquibase Pro now includes the ability to submit JCL jobs to the mainframe via Db2 DSNUTILU stored procedure. This enables users to automate more sophisticated procedures by integrating system level activities and database activities in a standard changelog format. This feature is enabled by a runwith:JCL decoration on applicable changesets containing properly formatted JCL.[INT-573, INT-1217]

• Improved Persistent Spool File Behavior for SQLPlus Executor. The SQLPlus executor ensures that spool files are always retained when --sqlplus-create-spool=true, giving users consistent access to output files. Previously, spool file retention was tied to the --sqlplus-keep-temp setting; now, this setting applies only to temporary SQL files, not spool files. This decoupling improves clarity and gives users more control—if a spool file is created, it will remain unless users opt out by setting --sqlplus-create-spool=false. [DAT-18983]

Policy Checks

• MongoChangetypeAttributes Policy Check. Introduced a new quality check named MongoChangetypeAttributes that allows users to enforce specific values or patterns for attributes within MongoDB-specific changetypes. Users can select a single Mongo changetype (e.g., createIndex, dropCollection) and specify expected values or patterns for its attributes. The check triggers if a specified attribute is present but does not match the defined value or regex—ensuring consistent standards across Mongo changesets. This supports validation across key changetypes attributes like adminCommand, createCollection, insertOne, and more, and enhances control and quality enforcement in MongoDB deployment pipelines. [DAT-18275]

[OSS]

Important dependency updates

• Liquibase OSS 4.33+ has Java 24 core build support.
• The liquibase-cdi and liquibase-cdi-jakarta modules are still supported, but have been removed from the OSS distribution to their own repositories at https://github.com/liquibase/liquibase-cdi and https://github.com/liquibase/liquibase-cdi-jakarta

⚠️[PRO] and [OSS] Upcoming Change in Distributions

Liquibase is evolving to better serve both open-source contributors and enterprise customers by introducing a clearer separation between its Open Source (OSS) and PRO offerings. This change is designed to ensure that each distribution is optimized for its respective users—providing open-source users with flexibility and control, while delivering scalability, reliability, and governance for enterprise teams.

The new structure enables Liquibase to more effectively support developers at all stages—from experimentation and community collaboration to mission-critical deployments. Liquibase 4.32.0 introduced the first general availability (GA) release of independently packaged Pro distributions, along with dedicated distribution channels and key-based access enforcement for Pro capabilities. This marks a significant step toward delivering a curated, enterprise-grade experience for Pro users.

The OSS distribution and its delivery channels remain unchanged in this phase.

• Learn more https://docs.liquibase.com/start/install/home.html

PRO PRs

🆕New Features

• [DAT-20202] Added ProJdbcExecutor in order to show SQL warning messages on compiler errors liquibase/liquibase-pro#2410 by @wwillard7800
• [DAT-20173] Changes to allow connection to Azure MI liquibase/liquibase-pro#2489 by @wwillard7800
• [DAT-20286] Added code to use the getVisibleUrl method for display of URL liquibase/liquibase-pro#2478 by @wwillard7800
• [INT-1318] Added application name to JDBC properties liquibase/liquibase-pro#2381 by @wwillard7800
• [DAT-18983] Always keep the spool file if it was created liquibase/liquibase-pro#2476 by @wwillard7800 Documentation: https://docs.liquibase.com/concepts/changelogs/attributes/run-with-spool-file.html
• [DAT-20132] support regular expressions for string comparisons liquibase/liquibase-checks#221 by @StevenMassaro
• [DAT-20134] remove sql from changeset compatibility list for MongoChangetypeAttributes liquibase/liquibase-checks#224 by @StevenMassaro
• [DAT-20133] add additional logging around AbstractChangetypeAttributesCheck when not checking change liquibase/liquibase-checks#223 by @StevenMassaro
• [DAT-20131] compare JSON in MongoChangetypeAttributes using JSON equivalence liquibase/liquibase-checks#220 by @StevenMassaro
• [INT-1361] added default collation to change DataTypeAttribute. liquibase/liquibase-pro#2457 by @SvampX
• [DAT-19897] Add InitPropertiesCommandStep to generate Liquibase properties summary liquibase/liquibase-pro#2245 by @filipelautert
• feat: Refactor Snowflake JDBC connection, removing all Snowflakedriver dependencies from this class liquibase/liquibase-pro#2436 by @filipelautert
• [DAT-19668] New message appears when using the --force flag with rollback-one-changeset, rollback-one-update, and update-one-changeset liquibase/liquibase-pro#2352 by @wwillard7800
• [DAT-20254] Use PercentEscaper to percent encode password for PostgreSQL liquibase/liquibase-pro#2369 by @wwillard7800
• [INT-1217] Implementation of JCL native executor liquibase/liquibase-pro#2244 by @wwillard7800
• [DAT-19978] Flow files will only look in resource accessor for relative paths liquibase/liquibase-pro#2387 by @StevenMassaro
• [INT-160] Custom DATABASECHANGELOG and DATABASECHANGELOGLOCK Table Generation for DB2z liquibase/liquibase-pro#2260 by @CharlesQueiroz
• [INT-1321] added 'order' attribute to the DataTypeAttribute database object liquibase/liquibase-pro#2376 by @SvampX
• [DAT-18275] MongoChangetypeAttributes changetype check liquibase/liquibase-checks#209 by @StevenMassaro

🐛Bug Fixes 🐛

• [DAT-20176] [DAT-20202] Liquibase displays SQL compiler errors if they occur. liquibase/liquibase-pro#2410 by @wwillard7800
• [INT-1362]: Fix of empty generated changelog in case when only type attributes order is different liquibase/liquibase-pro#2435 by @SvampX
• [DAT-20175] Correctly determine if stored logic is valid for Oracle liquibase/liquibase-pro#2366 by @wwillard7800
• [DAT-20193] Correctly labeled the AWS and RDS documentation to reflect that it is available to OSS users. liquibase/liquibase-docs@f104c3e by @AMBERMW13
• [DAT-20244] When a formatted SQL changelog is parsed and is found to have multiple header lines, the message will display: Duplicate formatted SQL header at line X #7036 by @wwillard7800
• [DAT-20282] The deployment summary no longer includes internal DATABASECHANGELOG updates in the "Rows affected" count. This prevents inconsistencies when no customer data is changed but the summary previously showed rows affected due to internal tracking. #7063 by @StevenMassaro
• [DAT-18983] SQLPlus Spool file saves if you set –sqlplus-create-spool: true or –sql-plus-keep-temp=true. Learn more here: runWithSpoolFile
• 🐛[DAT-20329] Sanitize URL before output Associated with PR 226 liquibase/liquibase-pro#2466 by @wwillard7800
• 🐛[DAT-20329] Sanitize URL before output - Associated with PR 2466 liquibase/liquibase-checks#226 by @wwillard7800

Version updates: In the pom.xml for Maven, update postgres to 42.7.7 liquibase/liquibase-pro#2486 by @abrackx

🔒Security, Driver and Other Updates

• [DA...

Liquibase 4.32.0 is a major release

Notable Changes

[PRO]

Policy Checks

Formatted SQL Header Policy Check. Introduced a new policy check named FormattedSqlHeaderRequired to ensure that.sql files included in changelogs begin with the required --liquibase formatted sql header. This check helps prevent improperly formatted SQL changes that could bypass Liquibase’s change tracking, auditing, and rollback features. This new policy check supports changelogs of any format (SQL, XML, YAML, JSON) and includes an EXCEPTIONS_LIST customization option to exclude specific files. When triggered, it lists all offending .sql files missing the required header, helping maintain the integrity and reliability of database change management. [DAT-19042]

Get Config Value Helper Function for Python Checks. Added a new helper function, liquibase_utilities.get_config_value(), for custom Python checks. This function enables easy access to standard Liquibase configuration properties—including those set via environment variables, CLI arguments, or defaults files. This enhancement simplifies scripting by allowing users to retrieve values such as url, loglevel, changelogfile, and custom properties like dbplatform or contexts directly within their Python checks, without manually resolving property names or sources. [DAT-19486]

Property Substitution in Python Check Script Arguments. Enhanced support for custom Python checks by allowing the use of Liquibase properties in the SCRIPT_ARGS section. Users can now reference properties—such as environment variables, CLI arguments, or values from the defaults file—using standard substitution syntax (e.g., ${liquibase.command.url} or ${PIPELINE_NAME}). This enables dynamic and context-aware scripting, such as configuring behavior based on runtime attributes like the current Git branch or target environment. [DAT-19377]

Absolute Path for Custom Python Policy Checks. Updated custom policy check support to allow Python script paths to be specified using absolute paths, in addition to relative paths. This enhancement enables users to store and reference custom check scripts from centralized or shared directories outside the local project repository, eliminating the need to duplicate scripts across multiple projects. This improves flexibility and promotes better reuse and maintenance of custom policy checks across teams and environments. [DAT-19408]

Audit and History

DBCLH History Command for MongoDB and DynamoDB. Added support for the liquibase dbcl-history command for MongoDB and DynamoDB users, enabling access to the DatabaseChangeLogHistory (DBCLH) table. This Liquibase Pro command outputs each DBCLH row as a JSON object, making it easy to integrate with BI and analytics tools. Users can customize output with --format=json|JSON_PRETTY and --verbose to control the level of detail in capturedsql and extensions fields. Output defaults to console but can be redirected to a file using --outputfile. [DAT-17162], [DAT-17164]

Observability and Reports

Drift Report Support for MongoDB Family. Liquibase Pro now supports Drift Report generation for the MongoDB database family, including MongoDB Atlas and AWS DocumentDB. This enhancement allows DevOps and SRE teams to detect schema drift and compare MongoDB instances using the same familiar workflow as relational databases. Drift Reports now include MongoDB-specific snapshot and diff outputs, while omitting or clearly marking relational-only fields as "Not Applicable for Mongo-type Databases." This feature enables consistent configuration checks across distributed NoSQL environments and helps ensure alignment between instances of application data stores. [INT-871]

Enhanced Drift Report Connection Detail. Improved drift reports generated by the liquibase diff command by including complete connection details. Source and target URLs now display full catalog and schema names—particularly valuable for platforms like Databricks—allowing users to accurately identify and distinguish the environments being compared. This enhancement provides greater clarity and helps streamline the process of reviewing and resolving discrepancies. [DAT-18910]

Sensitive SQL Content Suppression in Operational Reports. Added a new global --reports-suppress-sql option to prevent sensitive SQL content—such as passwords—from appearing in operational reports and CLI output (e.g., during update-sql or drift report generation). This setting helps improve security and reduce noise in reports, especially in CI/CD pipelines like Jenkins. When enabled, SQL output is replaced with a placeholder message (SQL suppressed). An optional companion flag, --reports-suppress-exceptions, controls whether SQL appears in error messages. It is automatically set to true when --reports-suppress-sql is enabled, unless explicitly overridden. Both flags are configurable via CLI, environment variables, or properties files. [DAT-19076]

Security

Kerberos Passwordless Authentication for runWith:psql. Liquibase Pro now supports Kerberos passwordless authentication with the runWith:psql native executor, enabling secure, credential-free connections in environments where plain user/password secrets are restricted. This enhancement ensures compatibility with Active Directory/Kerberos authentication workflows while preserving full functionality, including the generation of log spool files as configured in liquibase.psql.conf. Both Kerberos and non-Kerberos environments continue to be supported, ensuring seamless transitions and enhanced security compliance. [DAT-19525]

Simplified Snowflake OAUTH and PKI Authentication Support. Liquibase Pro now supports Snowflake OAUTH and Private Key Infrastructure (PKI) authentication through new dedicated properties, eliminating the need for manual JDBC URL customization in most cases. This enhancement ensures compliance with Snowflake’s upcoming requirement for token-based authentication (effective November 2025) and simplifies secure connectivity for all Snowflake users. Sensitive authentication details—such as tokens, private key paths, and passphrases—can now be provided via Liquibase properties with standard handling for logging and reporting, helping users adopt modern authentication methods with less complexity and greater security. [INT-190], [INT-182]

Workflow Automation

Conditional Flow File Logic Based on Action Exit Codes. Liquibase Pro now supports conditional flow file logic based on action exit codes, enabling more flexible and resilient automation. A new continueOnError property (default: false) allows flows to proceed even when an individual action fails. Additionally, the new exitCode value captures the exit code of the previous action. This allows users to write conditional logic (e.g., if: "exitCode <= 1") directly within flow files. This enhancement empowers users to handle errors and successes gracefully within a single flow, rather than halting execution entirely. [DAT-19490]

Change Automation

Composite Type Objects in PostgreSQL Support. Liquibase now supports Composite TYPE objects in PostgreSQL, enabling users to manage these objects more effectively. This feature allows users to create and drop Composite Types using Liquibase change types, with support for XML, YAML, and JSON formats. Auto-rollback functionality is also included for these change types, ensuring smooth execution and rollback. This enhancement fills the gap in PostgreSQL object support and provides a valuable tool to manage complex PostgreSQL data types with Liquibase. [INT-173], [INT-175]

PostgreSQL Composite Type Schema Change Support. Liquibase Pro now supports the changeCompositeTypeSchema change type for PostgreSQL, enabling users to manage schema changes for composite Type objects. This enhancement fills a gap in Postgres object support by allowing ALTER operations to move a Type between schemas. The change type is available in all modeled formats (XML, YAML, JSON) and includes auto-rollback functionality. [INT-1268]

PostgreSQL Composite Type Ownership Change Support. Liquibase Pro now supports altering the ownership of Composite Type objects in PostgreSQL through a new changeCompositeTypeOwner change type. This feature allows users to manage ownership changes using modeled formats (XML, YAML, and JSON), expanding Liquibase’s support for advanced PostgreSQL object types. Auto-rollback is not supported because the current owner cannot be determined. [INT-1266]

PostgreSQL Composite Type Rename Support. Liquibase Pro now supports renaming PostgreSQL Composi...

Liquibase 4.31.1 is a patch release

Notable Changes

[OSS]

logicalfilepath bug: in 4.31.0, the parent logicalfilepath value will be used in DBCL/DBCLH as the changelogfilepath value, as a result the changesets from the included changelogs that were deployed with the changelog level logicalFilePath in version 4.31.0 will be considered new and will be redeployed in the latest versions. 4.31.1 fixes this behavior and deployed changesets will not be redeployed.

[PRO] Changelog

🐛 Bug Fixes 🛠

• DAT-19579: The changesets from the included changelogs that were deployed with the changelog level logicalFilePath in version 4.31.0 will be considered new and will be redeployed in the latest versions #6716 @filipelautert

[OSS] Changelog

🐛 Bug Fixes 🛠

• (#6664) Don't ignore logicalFilePath when including changelogs @filipelautert
• (#6716) fix filename in dbcl incorrectly generated during 4.31.0 (#6712) @filipelautert

🤖 [OSS] Security, Driver and Other Updates

Snowflake vulnerability update CVE-2025-24789

• Snowflake discovered and remediated a vulnerability in the Snowflake JDBC Driver. Liquibase now includes a version with the fixed issue 3.22.0.

Full Changelog: v4.31.0...v4.31.1

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at https://learn.liquibase.com/.

Read the Documentation

Please check out and contribute to the continually improving docs, now at https://docs.liquibase.com/.

Join the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to making it stronger:

Contribute code
Make doc updates
Help by asking and answering questions
Join our Discord server
Sign up to provide feedback to the product team

Thanks to everyone who helps make Liquibase better!

File Descriptions

• Liquibase CLI -- Includes open source + commercial functionality
• liquibase-x.y.z.tar.gz -- Archive in tar.gz format
• liquibase-x.y.z.zip -- Archive in zip format
• liquibase-windows-x64-installer-x.y.z.exe -- Installer for Windows
• Primary Libraries - For embedding in other software
  • liquibase-core-x.y.z.jar – Base Liquibase library (open source)
  • liquibase-commerical-x.y.z.jar – Additional commercial functionality
• liquibase-additional-x.y.z.zip – Contains additional, less commonly used files
  • Additional libraries such as liquibase-maven-plugin.jar and liquibase-cdi.jar
  • Javadocs for all the libraries
  • Source archives for all the open source libraries
  • ASC/MD5/SHA1 verification hashes for all files

Liquibase 4.31.0 is a major release

⚠️ Breaking Change

Changesets with entirely blank IDs will now fail validation. This change improves the reliability and diagnosability of database changes, and enforces the best-practices set forth in documentation and training.

This validation does not apply to changesets that have already been deployed. However, any changesets marked as runOnChange or runAlways will fail validation if they have an empty changeset ID.

UPDATE: Reported Problems with LogicalFilePath

A few OSS users have reported a logicalfilepath bug, described below. This update aims to highlight potential trouble for users who meet three specific conditions:

1. Use Liquibase 4.31.0
2. Use the logicalfilepath attribute with different values at changelog and changeset levels
3. Use include/includeAll to nest changelogs

The Bug
The standard Liquibase practice is to accept the attribute closest to the changeset. But in 4.31.0, the parent logicalfilepath value will be used in DBCL/DBCLH as the changelogfilepath value.

What Next?
If your workflow meets the conditions mentioned above, please avoid upgrading to version 4.31.0. The issue will be resolved in the upcoming 4.31.1 release.

Notable Changes

[PRO]

New Checks extension delivered in the box

• Policy Checks are undoubtedly one of Liquibase Pro's stickiest capabilities, for which we continually add database platforms, new checks, and customizations. But to get these developments, users would need to download and upgrade to the latest Liquibase. Not any more! With this new checks extension, you can deploy the latest Policy Checks powers by optionally upgrading just the Check Extension on your cadence. Conveniently, this extension is delivered "in the box" at /internal/extensions, so you do not have to change anything about your current Policy Checks workflow.
• Learn more https://docs.liquibase.com/pro-extensions

Other Checks Enhancements

• Pro users can suppress sql in reports with the new global property: --reports-suppress-sql=true
• New checks-settings files can be created without CLI prompts by adding --force to checks show command
• By popular demand, checks reports now show all checks run, including those not triggered.
• We simplified the custom python check creation flow by removing the single-answer prompts/
• Learn more https://docs.liquibase.com/policy-checks

[OSS]

Liquibase capability enhancements

• Changesets with entirely blank IDs will fail validation. This is a breaking change.
  • NOTE: Validation should not fail for changes that have already been ran. Changes that have been ran with an empty changeset id that are marked as runOnChange or runAlways WILL fail validation.
• Added changeset execution time to output and logs
• Added calculated checksum to output of calculate-checksum command
• Added two new command parameters to history command so users can better see tagged deployments without having to directly examine the DATABASECHANGELOG table
  • show-tags will return only tagged deployment history
  • tag-filter will return deployment history for a specific tag or group of tags
• If an XML changelog is generate-changelog and fails to validate, Liquibase will indicate where the codepoint where the XML failure is located.
• Added new Spring properties for Pro license key and to disable analytics

Java API Changes

• Added missing changeLogParameters argument to generateChangeLog, calculateCheckSum, doChangeLogSyncSql, and changeLogSync

[PRO] Changelog

🚀 New Features

• DAT-19367: undo UUID-ing of deployment ID in liquibase/liquibase-pro#2108 by @StevenMassaro
• DAT-18519: Reverting cloneTable generic changeType in liquibase/liquibase-pro#2068 by @SvampX
• DAT-19302: combined dependabot PRs in liquibase/liquibase-pro#2093 by @StevenMassaro
• feat: light build script to be triggered by liquibase oss builds in liquibase/liquibase-pro#2082 by @filipelautert
• DAT-19242: Update error messaging for stub checks commands in liquibase/liquibase-pro#2081 by @abrackx
• Fixed dbclh-deployment_id column size in liquibase/liquibase-pro#2078 by @rberezen
• DAT-19049 Complete work to move all checks-related code to a new extension in liquibase/liquibase-pro#2066 by @wwillard7800
• DAT-19000: added 'cloneTable' changetype with no supported databases in liquibase/liquibase-pro#2064 by @SvampX
• DAT-17940: optionally suppress SQL in reports in liquibase/liquibase-pro#2036 by @StevenMassaro
• add PRO_LICENSE_KEY to liquibase-aws-extension in liquibase/liquibase-pro#2058 by @sayaliM0412
• DAT-18892: create checks show files without prompting in liquibase/liquibase-pro#2050 by @StevenMassaro
• DAT-18129: update checks run output for checks that are disabled but requested to be run in liquibase/liquibase-pro#2049 by @StevenMassaro
• DAT-18777 Add a snippet of the matching SQL to the console output in liquibase/liquibase-pro#2020 by @wwillard7800
• DAT-18868: Include successful checks in checks run report "Details by Check" section in liquibase/liquibase-pro#2048 by @abrackx
• DAT-17901 Pass the database instance in the scope for changelog parsing in liquibase/liquibase-pro#2042 by @wwillard7800
• DAT-18780: Add messaging for scripts that cannot execute when using MaxAffected checks in liquibase/liquibase-pro#2039 by @abrackx
• DAT-18793: replace slf4j-simple with slf4j-nop in liquibase/liquibase-pro#2038 by @StevenMassaro
• [PRO license rotation] Fixed typo for yugabyte repo in liquibase/liquibase-pro#2047 by @jandroav
• DAT-18836 - CPC: database scope checks should not ask "requires snapshot" in liquibase/liquibase-pro#2041 by @filipelautert
• DAT-15504: Migrate init project to core in liquibase/liquibase-pro#2004 by @abrackx
• DAT-18328 Update to match core for stripComments in modifyChangeSets in liquibase/liquibase-pro#1981 by @wwillard7800
• DAT-18841 Do not prompt for script type with CPC in liquibase/liquibase-pro#2027 by @wwillard7800
• DAT-10610 Added a flag to help trim down exception logging in liquibase/liquibase-pro#1997 by @wwillard7800
• DAT-18328 Add stripComments attribute to modifyChangeSets by @wwillard7800

🐛 Bug Fixes 🛠

• DAT-19045: fix string wrapping when it contains newlines in liquibase/liquibase-pro#2104 by @StevenMassaro
• DAT-19241 Help fixes for the stubs in liquibase/liquibase-pro#2077 by @wwillard7800
• DAT-18842 Fix issue where we were passing the wrong argument to the executor in liquibase/liquibase-pro#2006 by @wwillard7800

🤖 Security, Driver and Other Updates

• Bump actions/setup-python from 5.1.0 to 5.3.0 in liquibase/liquibase-pro#2008 by @dependabot bot
• Bump com.github.jsqlparser:jsqlparser from 4.9 to 5.0 in liquibase/liquibase-pro#1866 by @dependabot bot
• Revert "Bump com.github.jsqlparser:jsqlparser from 4.9 to 5.0" in liquibase/liquibase-pro#2044 by @StevenMassaro

[OSS] Changelog

💥 Breaking Changes

• (#6472) Fail validation for blank changeset IDs (DAT-18773) by @abrackx

🚀 New Features

• (#6371) Implement logic to selectively include/exclude columns in generate-changelog "data" export (Issue #3371, #6310) @catull
• (#6486) Update release-published.yml to get the previous version by @sayaliM0412
• (#6490) DAT-18995: populate proper client_payload for dry_run by @sayaliM0412
• (#6498) Change automated release file version to main by @tati-qalified
• (#6497) DAT-18995: default dry_run value to false by @sayaliM0412
• (#6415) Add flag to top-level Scope to suppress logging of exceptions in certain cases by @wwillard7800
• (#6451) Migrate init project command to core (DAT-15504) by @abrackx
• (#6514) DAT-18995 by @sayaliM0412
• (#6515) Recognize isIO environment variable for analytics (DAT-18906) by @StevenMassaro
• (#6509) Replace slf4j-simple with slf4j-nop (DAT-18793) by @StevenMassaro
• (#6373) Report which codePoint is illegal for XML data export by @catull
• (#6512) Liquibase API: Add missing changeLogParameters argument by @MalloD12
• (#6436) Check if the next character is out of string length by @fntz
• (#6494) Make changelog and changeset logical file path settings override includeAll setting (Issue #6493) by @wwillard7800
• (#6511) SQLFile: Add DBMS validation check by @MalloD12
• (#6528) Revert refactoring that broke structured logging by @StevenMassaro
• (#6516) Add new properties to Spring configuration (analytics enabled and pro license) by @filipelautert
• (#6553) Add liquibase-checks property by @wwillard7800
• (#6529) Do not propagate logical file path to included changesets from raw SQL changelogs (DAT-19040) by @wwillard7800
• (#6499) Optionally suppress SQL in reports (DAT-17940) by @StevenMassaro
• (#6557) Avoid retri...

Liquibase 4.30.0 is a major release

Notable Changes

[PRO]

Anonymous Analytics:

• Liquibase can now gather anonymous usage analytics when commands are run. No user-specific data will be gathered.

For Liquibase OSS users, this functionality is enabled by default, but can be opted-out of before any data is sent. For Liquibase Pro users, this is disabled by default with the ability to opt-in.

Gathering anonymous usage analytics allows us to better understand how Liquibase is actually being used by a very wide, diverse set of millions of users.

• Learn more https://docs.liquibase.com/analytics

Flow Enhancements: Detect pending changesets, and variable-variables

• There are two exciting Flow enhancements: the ability to condition action on presence of pending changesets, and the ability to use a global variable inside other global or stage variables, enabling variable-variables within flows.
• Learn more https://docs.liquibase.com/flow

[OSS]

Usability Improvements:

• Avoid ignoring caught exceptions, and instead return the exception and append the reason for better debugging.
• When using failOnError=false, changesets that failed will now show up in the default output.
• When using STRICT mode, update-to-tag will now throw an error when there is no tag specified or the tag specified does not exist.
• Added a Customizer that allows discovery of changesets that are not known to an application. This can be used to prevent an application's startup when discovering new, unexpected changesets before an update is made.

Deprecated: MacOS .dmg installer

• The MacOS dmg installer no longer ships with release artifacts. Please use the tar.gz or .zip release artifacts, or install via homebrew by running brew install liquibase

For a full list of improvements and bug fixes, see the [OSS] Changelog section.

[PRO] Changelog

🚀 New Features

• DAT-18202 Implement wildcard check name argument for enable/disable in liquibase/liquibase-pro#2000 by @wwillard7800
• DAT-17058: Add analytics in liquibase/liquibase-pro#1995 by @liquibot
• DAT-17568 Added exit command action in liquibase/liquibase-pro#1689 by @wwillard7800
• DAT-18689: Add extra information to failed changesets summary in liquibase/liquibase-pro#1996 by @filipelautert
• DAT-18114 Added more logging for formatted SQL parsing in liquibase/liquibase-pro#1994 by @wwillard7800
• DAT-18455 Add SQL file path to policy checks output in liquibase/liquibase-pro#1944 by @wwillard7800

Changes

• DAT-17581 Exit with a non-zero if the changelog did not validate in liquibase/liquibase-pro#1870 by @wwillard7800
• DAT-18540 Create new ReportWriter.open(String path) method that default to no-op in liquibase/liquibase-pro#1962 by @wwillard7800
• DAT-18092: Use xdg-open to open reports in browser on linux operating systems in liquibase/liquibase-pro#1948 by @abrackx
• DAT-18531 Clear out DBCL fast check cache before each Flow action in liquibase/liquibase-pro#1933 by @wwillard7800
• DAT-18362 Handle comments when parsing include/includeAll statements in liquibase/liquibase-pro#1959 by @wwillard7800
• DAT-18463 Implement a class to be used to capture the start/end positions of a regex check for line number output in liquibase/liquibase-pro#1979 by @wwillard7800
• DAT-18869: Obfuscate IO arguments in liquibase/liquibase-pro#1999 by @abrackx

🐛 [PRO] Bug Fixes 🛠

• DAT-18819: Fix dropall behavior with snowflake in liquibase/liquibase-pro#1987 by @abrackx
• DAT-18517 Handle expansion of variables when default values are involved in liquibase/liquibase-pro#1969 by @wwillard7800
• DAT-18327: improve startup performance in liquibase/liquibase-pro#1972 by @StevenMassaro
• Fix tests to use new CommandFactory.reset() method in liquibase/liquibase-pro#1952 by @wwillard7800

🤖 [PRO] Security, Driver and Other Updates

[OSS] Changelog

🚀 New Features

• (#6414) When using failOnError=false, changesets that failed will now show up in the default output. Thanks, @filipelautert
• (#6413) Ensure all failed changesets show in the exceptionChangesets. Previously, output summaries did not include changesets that failed when running failOnError=false (DAT-18689). Thanks, @filipelautert
• (#6169) When using STRICT mode, update-to-tag will now throw an error when there is no tag specified or the tag specified does not exist. Thanks, @MalloD12
• (#6410) Modified clob handling in loadData by checking the string passed to a CLOB type column. Thanks, @tati-qalified
  • By default this value will be interpreted as a path. If the file at that path exists, the file's contents will be inserted into the column. If not, the passed value will be inserted as-is.
• (#6067) Added additional modes for duplicateFileMode. Thanks, @k4pran
  • INFO - Logs when duplicate changelog files are found at the INFO level
  • DEBUG - Logs when duplicate changelog files are found at the FINE level
  • SILENT - Does not log when duplicate changelog files are detected
• (#6432) Added a Customizer that allows discovery of changesets that are not known to an application. This can be used to prevent an application's startup when discovering new, unexpected changesets before an update is made. Thanks, @raphw
• (#6288) Avoid ignoring caught exceptions, and instead return the exception and append the reason for better debugging. Thanks, @asolntsev
• (#6265) Enhanced include and includeAll to support logicalFilePath (DAT-18350). Thanks, @wwillard7800
• (#6300) Added method to reset command definitions cache in CommandFactory for testing. Thanks, @wwillard7800
• (#6280) Undeprecated StringUtil class (DAT-18538). Thanks, @MalloD12
• (#5223) Improved empty check style by using isEmpty String method. Thanks, @MalloD12
• BigQuery
  • (#6294) Suppress UnsupportedClassVersionErrors for Bigquery at info level (DAT-18534). Thanks, @filipelautert
• Databricks
  • (#6263) Fix generated column value for Databricks (DAT-18148). Thanks, @filipelautert
• Maven
  • (#6129) Support Hashicorp Vault settings in the Maven Plugin POM. Thanks, @wwillard7800
• MSSQL
  • (#6138) Added support for include columns in indexes. Thanks, @stephenatwell
• PostgreSQL
  • (#6402) Added pg_stat_statements and pg_stat_statements_info views to the list of system tables and views to prevent them from being dropped. Thank you, @rozenshteyn
  • (#6211) Updated PostgreSQL database major and minor versions. Thanks, @MalloD12

🐛 Bug Fixes 🛠

• (#6266) Fix CustomTaskRollback rollback bug where it was being called twice. Thanks, @momosetkn
• (#6205) Removed usage of the deprecated isEmpty() method. Thanks, @anton-erofeev
• (#6366) Improve startup performance (DAT-18327). Thanks, @StevenMassaro
• (#6407) Added filterable flag to ChangeLogParameter class (DAT-18811). Thanks, @abrackx
  • This enables users to use label filters such as @some-filter and still have values replaced from global changelog parameters like environment variables.
• (#6416) When determining the schema name make sure a value was found (DAT-18673). Thanks, @abrackx
• (#6418) Fix issue where context filters with @ symbols were not being executed properly (DAT-18843). Thanks, @abrackx
• (#6406) Test assertion code modification. (DAT-17568). Thanks, @wwillard7800
• (#6429) Check that getPriority method is correct for snapshot generators (DAT-18730). Thanks, @StevenMassaro
• (#6417) Revert "Remove unneeded inclusion of commons-io in liquibase-core pom.xml". Thanks, @catull
• (#6385) Do not check for nested database objects when using foreignKeyConstraintExists precondition (DAT-18624). Thanks, @abrackx
• (#5894) Do not strip "classpath:" when normalizing the path. Thanks, @andrus
• (#6359) Fix issue...

Liquibase 4.29.2 is a patch release

Notable Changes

[PRO]

Custom Policy Checks updates: Create and run Python-based checks which fit your specific needs.

• Liquibase checks have been opened to the world of Python development! This release fixes some minor issues so you can use your custom Python scripts as policy checks to solve your nuanced and techstack specific conditions for better risk mitigation, compliance, code quality, security, and more.
• Learn more https://docs.liquibase.com/custom-policy-checks
• Get the Checks extension to enable this capability: https://docs.liquibase.com/pro-extensions

Deprecation Notice

MacOS .dmg Installer to be removed in next release.

• This is the final Liquibase release in which the MacOS installer will be shipped. Both the tarball (the liquibase-x.y.z.tar.gz) and the .zip (liquibase-x.y.x.zip) are the preferred replaced options for MacOS users.
• Questions or comments? https://www.liquibase.com/contact-us

[PRO] Changelog

💥 Breaking Changes

• None

Changes

• DAT-18013: optionally suppress Liquibase SQL for *-sql commands in liquibase/liquibase-pro#1877 by @StevenMassaro
• DAT-17659: tagDatabase changes in formatted sql files in liquibase/liquibase-pro#1833 by @StevenMassaro
• DAT-18310: update CustomCheckDefaultValuesTest to check all parameters in liquibase/liquibase-pro#1887 by @StevenMassaro
• Now that report files are enabled by default, suppress them with git in liquibase/liquibase-pro#1886 by @wwillard7800
• DAT-17390: global setting for stripComments option in liquibase/liquibase-pro#1879 by @StevenMassaro
• DAT-18111: add "Report" word to title of update reports in liquibase/liquibase-pro#1890 by @StevenMassaro
• DAT-18182: show correct message when license expires on same day in liquibase/liquibase-pro#1885 by @StevenMassaro
• DAT-18342: Store Pro License Key in AWS Secrets Manager in liquibase/liquibase-pro#1896 by @sayaliM0412
• DAT-18063 Release lock after SQLPLUS timeout error in liquibase/liquibase-pro#1892 by @wwillard7800
• DAT-18360: only show expiration date message in checks run if expiration date is not null in liquibase/liquibase-pro#1895 by @StevenMassaro
• fix: expected output for help in liquibase/liquibase-pro#1900 by @filipelautert
• DAT-18396 - fix scripts resource caching in liquibase/liquibase-pro#1899 by @filipelautert
• DAT-18420 Change check that controls database checks to make sure they don't run just because we took a snapshot for a custom check in liquibase/liquibase-pro#1902 by @wwillard7800
• DAT-18440 Handle strict mode setting when doing auto rollback in liquibase/liquibase-pro#1909 by @wwillard7800
• DAT-18196: add method to LicenseService to allow custom invalid license message in liquibase/liquibase-pro#1917 by @StevenMassaro
• DAT-18389 Changing Quality Checks -> Policy Checks in liquibase/liquibase-pro#1906 by @wwillard7800

[OSS] Changelog

💥 Breaking Changes

• None

Changes

• 4.29.1 release in #6141 by @filipelautert
• DAT-17914 in #6158 by @sayaliM0412
• optionally suppress Liquibase SQL for *-sql commands (DAT-18013) in #6132 by @StevenMassaro
• changes in support of globally setting stripComments option (DAT-1739) in #6137 by @StevenMassaro
• Handle reporting of changes which are skipped due to license issues (DAT-17659) in #6114 by @wwillard7800
• DAT-17993 Improve diffChangelog between MSSQL and Oracle in #6094 by @filipelautert
• DAT-18250 DevOps :: Clean up branch build not working in #6162 by @jandroav
• compare contents of zip file against baseline (DAT-18324) in #6166 by @StevenMassaro
• maven flag for suppressLiquibaseSql (DAT-18273) in #6163 by @StevenMassaro
• Append included labels to the changeset labels when matching (DAT-16636) in #6159 by @wwillard7800
• chore: upgrade installer jdk version to 21.0.4+7 in #6119 by @filipelautert
• Fix serialization of DatabaseChangeLog with 'preConditions' for yaml in #6118 by @MalloD12
• Add additional duplicateFileMode options in #6067 by @k4pran
• Do not show update summary when using update-sql via maven plugin (DAT-18323) in #6168 by @abrackx
• Bump org.mariadb.jdbc:mariadb-java-client from 3.3.3 to 3.4.1 in #6113 by @dependabot
• fix case where expiration date is null in --version output (DAT-18360) in #6170 by @StevenMassaro
• Make Scope ID RNG no longer use SecureRandom (fix #6178 in #6179 by @danielthegray
• Use correct method for Maven updateSQL (DAT-18142) in #6198 by @wwillard7800
• DAT-18398 - Do not add version to shipped extensions + ignore current ones in #6197 by @filipelautert
• Fixes issue 6054: incorrect system table query on DB2 AS/400 platform in #6185 by @AlexCoolen
• Do not throw exception if data type is not supported by database in #6226 by @wwillard7800
• Do not release lock if not locked by this update * DAT-18370 in #6218 by @wwillard7800
• add method to LicenseService to allow custom invalid license message( DAT-18196) in #6232 by @StevenMassaro
• fix: EndDelimiter not working as expected since 4.29 in #6157 by @filipelautert
• Changing Quality Checks -> Policy Checks in #6204 by @wwillard7800
• fix release workflows in #6260 by @jandroav
• chore: restore DAT-18398 changes by @filipelautert

🤖 Security, Driver and Other Updates

New Contributors

Full Changelog: v4.29.1...v4.29.2

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at https://learn.liquibase.com/.

Read the Documentation

Please check out and contribute to the continually improving docs, now at https://docs.liquibase.com/.

Meet the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to making it stronger:

Contribute code
Make doc updates
Help by asking and answering questions
Set up a chat with the Product team

Thanks to everyone who helps make the Liquibase community strong!

File Descriptions

• Liquibase CLI -- Includes open source + commercial functionality
• liquibase-x.y.z.tar.gz -- Archive in tar.gz format
• liquibase-x.y.z.zip -- Archive in zip format
• liquibase-windows-x64-installer-x.y.z.exe -- Installer for Windows
• liquibase-macos-installer-x.y.z.dmg -- Installer for MacOS
• Primary Libraries - For embedding in other software
  • liquibase-core-x.y.z.jar – Base Liquibase library (open source)
  • liquibase-commerical-x.y.z.jar – Additional commercial functionality
• liquibase-additional-x.y.z.zip – Contains additional, less commonly used files
  • Additional libraries such as liquibase-maven-plugin.jar and liquibase-cdi.jar
  • Javadocs for all the libraries
  • Source archives for all the open source libraries
  • ASC/MD5/SHA1 verification hashes for all files

Liquibase 4.29.1 is a patch release

Notable Changes

[PRO]

Liquibase 4.29.1 .zip files: Restored to standard directory structure

• This release correctly places Liquibase .zip files inside liquibase-4.29.1 directory to match Pre-4.29.0 directory structure.

Big Query Extension: using Liquibase Pro with Google Big Query

• With Liquibase 4.29.1, Google BigQuery is now supported as an ‘out of the box’ database enabling users to more quickly achieve value. Also included is support for Liquibase Pro features such as Flows, Policy Checks, and Reports with Google BigQuery so that users will have the efficiency and productivity benefits of Liquibase Pro when working with the platform.

• Learn more https://docs.liquibase.com/bigquery

[PRO] Changelog

🐛 [PRO] Bug Fixes 🛠

• DAT-18294: Correctly default check scope parameter in liquibase/liquibase-pro#1880 by @wwillard7800
• DAT-18308: DevOps :: Extensions are built against liquibase 0-SNAPSHOT https://github.com/liquibase/liquibase-pro/pull6144

🤖 [PRO] Security, Driver and Other Updates

• None

Full Changelog: v4.29.0...v4.29.1

Get Certified

Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at https://learn.liquibase.com/.

Read the Documentation

Please check out and contribute to the continually improving docs, now at https://docs.liquibase.com/.

Meet the Community

Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to making it stronger:

Contribute code
Make doc updates
Help by asking and answering questions
Set up a chat with the Product team

Thanks to everyone who helps make the Liquibase community strong!

File Descriptions

• Liquibase CLI -- Includes open source + commercial functionality
• liquibase-x.y.z.tar.gz -- Archive in tar.gz format
• liquibase-x.y.z.zip -- Archive in zip format
• liquibase-windows-x64-installer-x.y.z.exe -- Installer for Windows
• liquibase-macos-installer-x.y.z.dmg -- Installer for MacOS
• Primary Libraries - For embedding in other software
  • liquibase-core-x.y.z.jar – Base Liquibase library (open source)
  • liquibase-commerical-x.y.z.jar – Additional commercial functionality
• liquibase-additional-x.y.z.zip – Contains additional, less commonly used files
  • Additional libraries such as liquibase-maven-plugin.jar and liquibase-cdi.jar
  • Javadocs for all the libraries
  • Source archives for all the open source libraries
  • ASC/MD5/SHA1 verification hashes for all files

Liquibase 4.29.0 is a major release

Notable Changes

[PRO]

Big Query Extension: using Liquibase Pro with Google Big Query

• With Liquibase 4.29.0, Google BigQuery is now supported as an ‘out of the box’ database enabling users to more quickly achieve value. Also included is support for Liquibase Pro features such as Flows, Policy Checks, and Reports with Google BigQuery so that users will have the efficiency and productivity benefits of Liquibase Pro when working with the platform.
• Learn more https://docs.liquibase.com/bigquery

Operation Reports: Enabled by default

• With Liquibase 4.29.0, Operation reports for key Liquibase commands are generated and presented to users who meet the following conditions: running Liquibase commands which generate reports, on systems with read/write permissions, which are not "headless" in automation, and who have not explicitly set LIQUIBASE_REPORTS_ENABLED=false.
• Learn more at https://docs.liquibase.com/operation-reports

Custom Policy Checks: Create and run Python-based checks which fit your specific needs.

• Liquibase checks have been opened to the world of Python development! With this release, you can point your custom checks to your custom Python scripts to solve your nuanced conditions for better risk mitigation, compliance, code quality, security, and more. (Extension release: 29 July 2024)
• Learn more https://docs.liquibase.com/custom-policy-checks

[PRO] Changelog

🚀 New Features

• DAT-16671: Custom policy checks in liquibase/liquibase-pro#1671 by @wwillard7800
• DAT-17725: Enable reporting by default, swallow all report generation exceptions in liquibase/liquibase-pro#1763 by @abrackx
• DAT-17871: allow multiple checks to be specified in checks enable/disable commands in liquibase/liquibase-pro#1814 by @StevenMassaro
• DAT-17490: Enhance up* DATe report to split skipped changesets into their own collapsible section in liquibase/liquibase-pro#1752 by @abrackx
• DAT-17635: add wildcard support for check-name param for checks run, show, bulkset in liquibase/liquibase-pro#1787 by @StevenMassaro

Changes

• DAT-17988: PRO: checks run --checks-output=nonapplicablechecks is broken in liquibase/liquibase-pro#1792 by @wwillard7800
• DAT-17870: add aliases for parameters in checks run, show, and create commands in liquibase/liquibase-pro#1799 by @StevenMassaro
• DAT-17972: abstract report writing to interface for IO in liquibase/liquibase-pro#1795 by @StevenMassaro
• DAT-18086: update minor versions for Azure Uber Jar in liquibase/liquibase-pro#1868 by @filipelautert
• DAT-17654: add test for starting and stopping H2 in detached mode in liquibase/liquibase-pro#1735 by @StevenMassaro
• DAT-17883 Actually expand java and defaults file properties when using --property-substitution-enabled flag in liquibase/liquibase-pro#1782 by @abrackx
• DAT-15723: include arguments in generated drop function changes for Postgres in liquibase/liquibase-pro#1765 by @StevenMassaro
• DAT-17621: add ChangesetAttributesSetTrueOrFalse check in liquibase/liquibase-pro#1754 by @StevenMassaro
• DAT-17657 Handle non-String arguments in Flow in liquibase/liquibase-pro#1721 by wwillard7800
• DAT-16603 Do not append to open stream in flow in liquibase/liquibase-pro#1738 by @wwillard7800
• DAT-8223: add split statements option to SqlUserDefinedPatternCheck in liquibase/liquibase-pro#1744 by @StevenMassaro
• DAT-17535: up* DATe parameters for regex helper checks in liquibase/liquibase-pro#1716 by @StevenMassaro
• DAT-15916 Give each SQLCMD log file a unique name by adding the change set author and id in liquibase/liquibase-pro#1732 by @wwillard7800
• DAT-16597: fully qualify names when loading DDL of sprocs and funcs in Snowflake in liquibase/liquibase-pro#1724 by @StevenMassaro

🐛 [PRO] Bug Fixes 🛠

• DAT-18207: Do not open report when headless is true in liquibase/liquibase-pro#1843 by @abrackx
• DAT-18052: make check-name case-insensitive for checks bulk-set in liquibase/liquibase-pro#1815 by @StevenMassaro

🤖 [PRO] Security, Driver and Other Updates

[OSS] Changelog

💥 Breaking Changes

• (#6089) refactor history command to use command framework (DAT-17970) @StevenMassaro

Changes

• (#6042) Fix/windows value DAT-17704 @sayaliM0412
• (#5704) Fix SQL execution issue with endDelimiter '/' and splitStatements @MalloD12
• (#6037) DAT-17939 fix java version to 17 @jandroav
• (#6032) DAT-17939 Add ability to generate Liquibase zip with extensions for any PR @jandroav
• (#6017) Fix issue 5944 @MalloD12
• (#5925) feat: FastCheck refactoring @filipelautert
• (#5802) refactored data clumps @compf
• (#6022) Changed condition to trigger tests @rberezen
• (#5988) High Level API (aka undeprecate Liquibase class) @filipelautert
• (#5929) add detached mode for running H2 (DAT-17654) @StevenMassaro
• (#5993) Move ChangeLogParameters helper methods to ChangeLogParameters class (DAT-17883) @abrackx
• (#5766) Use lombok getter and setter. @asashour
• (#5982) DAT-17770 Package BQ commercial jar inside liquibase tar ball & zip @jandroav
• (#5985) DAT-16264 DevOps :: liquibase build fails on Publish to Maven Central - Nexus @jandroav
• (#5986) fix incorrect line breaks and wrapping when generating table output (DAT-17891 and DAT-17288) @StevenMassaro
• (#5911) Fix sequenceExists check that became case sensitive for Postgresql @davidecavestro
• (#5598) Changeset execution information properties @jasonlyle88
• (#5774) Prevent spurious SET SEARCH_PATH SQL statements for Postgres during update-sql command. Fixes #5316 @mpvvliet
• (#5875) GH issue #5872 improve regex for endDelimiter and rollbackEndDelimiter @wwillard7800
• (#5957) retain original dbms string (DAT-17621) @StevenMassaro
• (#5980) DAT-17768 - Add new directory internal/ext to classpath @filipelautert
• (#5977) fully qualify names of tables when snapshotting unique constraints in Snowflake (DAT-17880) @StevenMassaro
• (#5950) add default constructor + setters to DatabaseChangeLogLock @rursprung
• (#5961) Make the message be more accurate when an exception occurs during database close @wwillard7800
• (#5967) DAT-17842 @suryaaki2
• (#5898) Do not log stack trace if isExpected flag is true for CommandFailedException @wwillard7800
• (#1826) Prevent silent failures when two "databaseChangeLog" tags are present @danielthegray
• (#5953) CheckSum: add getter for storedCheckSum @rursprung
• (#901) Microsoft SQL Server doesn't support ORDER in sequences @danielthegray
• (#5915) Added connect command to Maven DAT-17411 @wwillard7800
• (#5932) use Commons-IO where possible (DAT-17634) @StevenMassaro
• (#5812) DAT-16825 ...

Liquibase 4.28.0 is a major release

Notable Changes

[PRO]

DATABASECHANGELOGHISTORY table with Big Query: See all changes that have been applied with Big Query

• Liquibase uses the DATABASECHANGELOGHISTORY (DBCLH) table to record a history of all changes made to the database. Unlike the DATABASECHANGELOG table that only shows active changes, the DBCLH shows all historical changes, including those that have been rolled back, dropped, or cleared. The DBCLH is now available for Big Query users.
• Learn more https://docs.liquibase.com/databasechangeloghistory

Flow file usage enhancements: Full strings as single variable values, and nested variables for "double-expansion"

• Flow files have been enhanced to allow multi-part args to be expanded from a single variable. Think cmdArgs: { "${COMMAND_ARGS}" }, which allows for more dynamic customization in the flowfile operations. Similarly, variables can include variables when expanded, which will in turn be expanded before processing.
• Learn more https://docs.liquibase.com/flow

Formatted SQL changelog enhanced with include/includeAll functionality

• Bringing parity to formatted sql users, we are happy to announce include and includeAll capabilities from within formatted sql changelogs.
• Learn more https://docs.liquibase.com/change-types/home.html#miscellaneous

New --pro-strict flag: Catch missing Pro resource files early!

• A new optional pro parameter which alerts users when specified paths to Pro resource files (flow files, checks settings files, native executor conf files, etc) or rollback scripts are missing or empty.
• Learn more https://docs.liquibase.com/parameters/pro-strict.html

[PRO] Changelog

• DAT-17543: Handle chained checks which have been skipped because of a scope mismatch in liquibase/liquibase-pro#1697 by wwillard7800
• DAT-16275: automatically open generated reports in browser in liquibase/liquibase-pro#1703 by StevenMassaro
• DAT-17485: always show update summary message in update report in liquibase/liquibase-pro#1708 by StevenMassaro
• DAT-17096: Turn on reports by default in liquibase/liquibase-pro#1675 by @abrackx
• DAT-17630: Rework logic for checking for database connection in liquibase/liquibase-pro#1706 by wwillard7800
• DAT-17400: add Snowflake integration tests in liquibase/liquibase-pro#1693 by StevenMassaro
• DAT-17540: Rename MaxRowsAllowed and added two more checks for update and delete in liquibase/liquibase-pro#1686 by wwillard7800
• DAT-17348: add condition evaluation details to conditions which evaluate to true in liquibase/liquibase-pro#1688 by StevenMassaro
• DAT-15920: error if native executor conf file or rollback file is not found and pro-strict is true in liquibase/liquibase-pro#1663 by StevenMassaro
• DAT-17601 Expand variables that are included in flow files liquibase/liquibase-pro#1694 by wwillard7800
• DAT-17322: PRO :: enable include/includeAll within formatted sql changelogs

🤖 [PRO] Security, Driver and Other Updates

[OSS] Changelog

💥 Breaking Changes

• (#5619) Improve snapshot extensibility for NoSQL databases @fbiville
• (#5729) remove ValueHandlerUtil and improve CLI argument parsing (DAT-15398) @StevenMassaro

Changes

• (#5822) test PR for azure uber @sayaliM0412

🚀 New Features

• (#5899) H2 tests may end up with an incorrect list of the standard DatabaseObject types, so we need to reset the factory @wwillard7800
• (#5897) chore: invoke deprecated methods in default supports method for backwards compatibility @filipelautert
• (#5870) only run drop all if database was used in the test @StevenMassaro
• (#5848) do not allow arguments with default values to be required (DAT-17436) @StevenMassaro
• (#5833) Use Java 8 features @asashour
• (#5767) Ensure a new-line at the end of text files. @asashour
• (#5814) refactor ValidatingVisitor to use factory pattern, error if strict is set and defaults file does not exist (DAT-15920) @StevenMassaro
• (#5716) Fix typos @asashour
• (#5782) Update ChangeSetService to handle new ModifyChangeset creation (DAT-17322) @wwillard7800
• (#5715) Add @Deprecated annotation. @asashour
• (#5828) Improve diffChangelog error message @filipelautert
• (#5799) Add new lifecycle methods for UpdateTestingRollbackCommandStep (DAT-15641) @abrackx
• (#5780) Deprecate ThreadLocalScopeManager as it is no longer required @filipelautert
• (#5714) Introduce a method with a correct name of StringUtil.randomIdentifer(). @asashour
• (#5793) move output file handling into factory pattern (DAT-17290) @StevenMassaro
• (#5741) Implement Customizer for SpringLiquibase. @asashour
• (#5777) Prevent error when unlocking the changelog in MySQL affects zero rows and useAffectedRows is true. Fixes #5502 @mpvvliet
• (#5619) Improve snapshot extensibility for NoSQL databases @fbiville
• (#5658) User lombok Getter and Setter. @asashour
• (#5532) Record current Liquibase version on a RERUN changeset (#5529) @jdvorak001
• (#5745) Add method that can be used to verify database connection (DAT-16600) @vitaliimak
• (#5705) upgrade groovy, spock and mockito to later versions (DAT-10403) @StevenMassaro
• (#5861) Update db2 docker location by @filipelautert
• (#5860) chore: increasing test coverage by @filipelautert
• (#5853) use Apache Commons where possible, instead of homegrown solutions (DAT-17303) by @StevenMassaro
• (#5867) cleanup weekly-integration-tests.yml (DAT-17400) by @StevenMassaro
• (#4240) PD-3241: failOnError syntax by @adrian-velonis1
• (#5871) load shared database fields in tests by @StevenMassaro

🐛 Bug Fixes 🛠

• (#5908) BUGFIX Azure jar wrong suffix @jandroav
• (#5795) Fixes issue with incorrect schema in column exists precondition when checking using a snapshot @mpvvliet
• (#5783) Fixed issue that unique constraint precondition does not honor schemaName attribute on MySQL @mpvvliet
• (#5874) refactor cached prepared statement to become ThreadLocal (#5635) @adaryin
• (#5888) normalize paths in DatabaseChangeLog using commons-io (DAT-17592) @StevenMassaro
• (#5887) Fix ordering of clause for Oracle global temporary tables SQL generation @wwillard7800
• (#5869) Update diff summary results in mdc to not be recalculated (DAT-17096) @abrackx
• (#5756) Fix (MSSQL): end delimiter logic broken by BEGIN DIALOG/BEGIN CONVERSATION @MalloD12
• (#5781) Fix (MSSQL): default end delimiter applied when there is an endDelimiter applied for a given chanset @MalloD12
• (#5883) Issue 5654 includeall min max depth fixes @jasonlyle88
• (#5842) optimize DBCL checksum query and set fetch size on all statements (DAT-17267) @StevenMassaro
• (#5846) DAT-17566 @sayaliM0412
• (#5794) fix calculation of total change sets in update summary (DAT-17262) @StevenMassaro
• (#5792) fix: keep indexes list in the order returned by database @filipelautert
• (#5703) Also replace '@' character in temporary file names DAT-17292 @wwillard7800
• (#5727) fixes #5724: compare normalized file paths @jgarec
• (#5755) detect duplicate jars that do not have a version (DAT-16044) @StevenMassaro
• (#5687) fix: addColumn changes are not respecting Datatypes definitions @filipelautert
• (#5580) Support to generate a ChangeSetStatus with setting all its attributes when a changeset will be skipped @MalloD12
• (#5751) New boolean input logic allows 'off' to be valid, so fix test @wwillard7800
• (#5881) Update codeql.yml by @sayaliM0412
• (#5891)DAT-17618: Update fossa_ai.yml to use authorize by @sayaliM0412

🤖 Security, Driver and Other Updates

Liquibase 4.27.0 is a major release

Notable Changes

[PRO]

Liquibase DATABASECHANGELOGHISTORY table: See all changes that have been applied to your database

• With the new DatabaseChangeLogHistory (DBCLH) Table, get a complete history of changes made to your database through Liquibase operations, including updates, rollbacks, dropAlls, tags, changelogsyncs, and repeated updates to the same ChangeSet. The DBCLH table is disabled by default, so Users must turn it on to start capturing historical data.
• Learn more https://docs.liquibase.com/databasechangeloghistory

Quality Checks Chains: Perform multiple policy evaluations with a single Quality Check

• Chain multiple Quality Checks together with logic conditionals (AND, OR, and NOT) for more flexibility to perform multiple evaluations in a single check. Useful to confirm complex best practices or governance issues. Check Chains are run like traditional single-condition existing Quality Checks
• Learn more https://docs.liquibase.com/quality-checks

Observability: Rollback Reports: Understand and share the data on the execution of rollback commands

• Easily scan and understand a high-level overview of the ChangeSets rolled back. Get a detailed view of both successful and failed rollbacks. Collaborate with your team with shareable report in PDF format
• Learn more https://docs.liquibase.com/observability

Breaking Change

• (#5584) throw exception if drop all fails (DAT-16718) @StevenMassaro

[PRO] Changelog

• DAT-16798: Style rollback reports in liquibase/liquibase-pro#1534 by @abrackx
• DAT-16857: record operationOutcome in MDC in liquibase/liquibase-pro#1606 by StevenMassaro
• DAT-16853: Chained checks reports in liquibase/liquibase-pro#1580 by @abrackx
• DAT-16127 Checks chaining implementation in liquibase/liquibase-pro#1500 by wwillard7800
• DAT-16178: database changelog history record-keeping in liquibase/liquibase-pro#1334 by StevenMassaro
• DAT-16092 Implemented checkStatus argument for filtering by enabled/disabled status in liquibase/liquibase-pro#1577 by wwillard7800
• DAT-17187: Add check rollbacks to runtime metadata in https://github.com/liquibase/liquibase-pro/pull/ by @abrackx
• DAT-16920: add path filter option to SqlUserDefinedPatternCheck in liquibase/liquibase-pro#1575 by StevenMassaro
• DAT-17072 Added new autoEnableNewChecks option and fix bug with autoUpdate in liquibase/liquibase-pro#1566 by wwillard7800
• DAT-16420: add propertySubstitutionEnabled flag to checks run command in liquibase/liquibase-pro#1569 by StevenMassaro
• DAT-16845: exclude unnecessary directories/files from built jar in liquibase/liquibase-pro#1565 by StevenMassaro
• DAT-15170: add EndDelimiterExistsWhenPatternExists QC in liquibase/liquibase-pro#1517 by StevenMassaro
• DAT-16559: Add copy url button to checks run and update reports in liquibase/liquibase-pro#1521 by @abrackx
• DAT-16770: Fix table styling in details by check in liquibase/liquibase-pro#1531 by @abrackx
• DAT-16683 Implement snapshot filters for snapshotReference command in liquibase/liquibase-pro#1506 by wwillard7800
• DAT-15980 Added new CheckRunInTransactionValue rule in liquibase/liquibase-pro#1516 by wwillard7800
• DAT-16544 Fix issue with bad SQL generation in liquibase/liquibase-pro#1512 by wwillard7800
• DAT-14830: warn if running checks bulk-set without arguments in liquibase/liquibase-pro#1592 by StevenMassaro
• DAT-16105: improve interactive prompting through Powershell ISE in liquibase/liquibase-pro#1581 by StevenMassaro
• DAT-16765: throw exception when using init copy on non-s3 paths in liquibase/liquibase-pro#1539 by StevenMassaro
• PD-3246: init copy --source/--target descriptions in liquibase/liquibase-pro#946 by adrian-velonis1
• DAT-16271: properly handle creating procedure with no args and external name in liquibase/liquibase-pro#1494 by StevenMassaro
• DAT-16567 Handle logFormat when set in a flow file in liquibase/liquibase-pro#1522 by wwillard7800
• DAT-16306: wrap INITCOND of Postgres aggregate functions in single quotes in liquibase/liquibase-pro#1502 by StevenMassaro

🤖 [PRO] Security, Driver and Other Updates

[OSS] Changelog

💥 Breaking Changes

• (#5584) throw exception if drop all fails (DAT-16718) @StevenMassaro

🚀 New Features

• (#5692) Add force option to dropAll DAT-16418 @wwillard7800
• (#5630) DAT-16798: Add new parameters to rollback report @abrackx
• (#5649) Add CustomChangeChecksum interface @robinjhector
• (#5147) database changelog history record-keeping (DAT-16178) @StevenMassaro
• (#5709) feat: add commons-lang3 as a required dependency for core @filipelautert
• (#5670) 5507-performance_improvements @filipelautert
• (#5667) Exception handler for when a service cannot be loaded @filipelautert
• (#5650) DAT-16513 - Upgrade installer Java version to 21 @filipelautert
• (#5456) Extended formatted sql preconditions by table-/viewExists @JulienMa94
• (#5597) Format spring package. @asashour
• (#5592) Bring update summary options to all update-relat...