logicalFilePath

The logicalFilePath attribute is used to override the file name and path when creating the unique identifier of changesets. The logicalFilePath attribute is required when moving or renaming changelogs to prevent Liquibase from redeploying the corresponding changesets as their unique identifier will have been changed by the move.

You can specify the logicalFilePath attribute in the root section of the <databaseChangeLog> in your changelog or in a specific changeset.

Uses

Liquibase uses the following pattern to create a unique identifier for a changeset: id/author/filepath.

Even if the same file is referenced by a different filepath, it is considered a different file by Liquibase because of the unique identifier definition. The logicalFilePath attribute is used to override this behavior for one of the following purposes.

You have multiple developers sharing a changelog file

If multiple developers are sharing a changelog file and their filepaths are not identical, Liquibase may attempt to repeat the execution of the changesets to the target database unless the logicalFilePath is used.

Here are some example filepaths for two developers:

  • searchPath=/Users/developer-1/

  • searchPath=/Users/developer-2

These file paths examples allow developers to always have the same changelog path.

The logicalFilePath would need to be used in this example to override the specific developers filepath so that Liquibase would not attempt to rerun the changeset files.

Code restructuring results in a new filepath for the changelog

Another example of when logicalFilePath must be used is during code restructuring. If code restructuring results in a new filepath for a changelog, the logicalFilePath attribute can be used to prevent Liquibase from attempting to rerun the previously deployed changesets.

In this example, a changelog is being moved:

  • Previous location:db/changelog/db.changelog-1.0.xml

  • New location: db/changelog-1.0/db.changelog.xml

The logicalFilePath for the changelog would need to be set to /src/main/resources/db/changelog/db.changelog-1.0.xml to prevent Liquibase from redeploying the changesets to the database.

You want to prevent changeset id conflicts between modules

The logicalFilePath can also be used as a unique identifier to prevent duplicate changeset ids between modules from causing Liquibase collisions. If there are multiple libraries in the application and each manages its own changelog files

Root changelog versus changeset level

If the logicalFilePath is set in the root element in the changelog format, the logical path is used for all changesets within the file.

You can set the logicalFilePath within specific changesets. This allows you to set different file paths for each changeset. If it is set in both places, the changeset-level path takes precedence. Setting the logicalFilePath for specific changesets can be used when an individual changeset is moved from one file to another as part of a changelog restructuring project. Inheriting logicalFilePath in included changelogs

If you use theincludetag to reference changelogs that don't define their ownlogicalFilePath, those changelogs inherit thelogicalFilePathof their parent changelog by default. This means you don't have to explicitly setlogicalFilePathon every included file to protect your changeset tracking history when moving or renaming files.

You can control this behavior with theALLOW_INHERIT_LOGICAL_FILE_PATHglobal configuration property.

Configuration property

ALLOW_INHERIT_LOGICAL_FILE_PATH

Environment variable

LIQUIBASE_ALLOW_INHERIT_LOGICAL_FILE_PATH

Type

Boolean

Default

false

Description

Controls whether included changelogs that do not define an explicitlogicalFilePathinherit thelogicalFilePathof their parent changelog. When true, included changelogs inherit the parent'slogicalFilePath, protecting changeset tracking history if you move or rename files. When false, included changelogs use their physical file path, which is the default Liquibase behavior. If the included changelog does not define an explicitlogicalFilePath, it inherits the parent changelog'slogicalFilePathby default. This protects your changeset tracking history in theDATABASECHANGELOGtable if you move or rename files. To disable this behavior and use physical file paths instead, setALLOW_INHERIT_LOGICAL_FILE_PATHto false in your global configuration.

Syntax

The logicalFilePath attribute be any string, although it is often set to original/legacy path names.

Changelog examples

For a changelog

--liquibase formatted sql logicalFilePath:com/example/old-path.xml --changeset your.name:1 create table company ( id int primary key, name varchar(50) not null, address1 varchar(50), address2 varchar(50), city varchar(30) ) --rollback drop table company

For a changeset

--changeset your.name:1 logicalFilePath:com/example/old-path.xml