Preconditions in Liquibase

Date: 2025-03-14

Liquibase's preconditions feature ensures database integrity by validating conditions before executing changesets. Preconditions, defined within <preConditions> tags, can be global (affecting all changesets) or local (affecting a single changeset). They utilize various onFail strategies (HALT, MARK_RAN, etc.) to control execution upon failure. Conditions can check database type, user roles, table/column existence, and are combinable using logical operators (AND, OR, NOT). This ensures database changes only occur under specific, pre-validated circumstances, minimizing errors and enhancing the reliability of database migrations.

Read more: https://www.javacodegeeks.com/liquibase-preconditions-example.html