Automatically create a snapshot and run checks

Last updated: November 18, 2025

Automatically create a snapshot of the database using a live database URL and enable a database-scoped check.

Procedure

1

Establish the url and referenceUrl in the liquibase.properties file.

liquibase.command.url: jdbc:h2:tcp://localhost:9090/mem:dev
liquibase.command.referenceUrl: jdbc:h2:tcp://localhost:9090/mem:integration
This establishes the automatic snapshot.
2

Run the liquibase checks run --checks-scope=database command.

liquibase checks run --checks-scope=database command

--checks-scope=changelog example

Starting Liquibase at 16:35:11 (version [Core: //DAT-9298/2516/e42617/2022-05-11 19:02+0000, Pro: DAT-9298/1208/56ac6a/2022-05-11T18:56:15Z] #2516 built at 2022-05-11 19:02+0000) Liquibase Version: [Core: //DAT-9298/2516/e42617/2022-05-11 19:02+0000, Pro: DAT-9298/1208/56ac6a/2022-05-11T18:56:15Z] Liquibase Empire [Core: //DAT-9298/2516/e42617/2022-05-11 19:02+0000, Pro: DAT-9298/1208/56ac6a/2022-05-11T18:56:15Z] by Liquibase licensed to Dev until Sat Dec 30 21:59:59 MST 2023 Executing Policy Checks against amber-createTable-changelog.xml Executing all changelog checks because a valid license key was found! CHANGELOG CHECKS ---------------- Checks completed validation of the changelog and found the following issues: Changeset ID: 1::createTableforSynonym-PROSCHEMA Changeset Filepath: amber-createTable-changelog.xml Check Name: Check Table Column Count (TableColumnLimit) Check Severity: MINOR (Return code: 1) Message: Table must not have more than 2 columns. Changesets Validated: ID: 1::createTableforSynonym-PROSCHEMA; Author: Liquibase Pro User; File path: amber-createTable-changelog.xml Checks run against each changeset: Check Table Column Count Liquibase command 'checks run' was executed successfully.

--checks-scope=database example

Starting Liquibase at 12:18:24 (version [Core: //DAT-9298/2516/e42617/2022-05-11 19:02+0000, Pro: DAT-9298/1208/56ac6a/2022-05-11T18:56:15Z] #2516 built at 2022-05-11 19:02+0000) Liquibase Version: [Core: //DAT-9298/2516/e42617/2022-05-11 19:02+0000, Pro: DAT-9298/1208/56ac6a/2022-05-11T18:56:15Z] Liquibase Empire [Core: //DAT-9298/2516/e42617/2022-05-11 19:02+0000, Pro: DAT-9298/1208/56ac6a/2022-05-11T18:56:15Z] by Liquibase licensed to Dev until Sat Dec 30 21:59:59 MST 2023 Executing Policy Checks against database jdbc:h2:tcp://localhost:9090/mem:dev Executing all database checks because a valid license key was found! INFO This command might not yet capture Liquibase Pro additional object types on h2 Database objects Validated: Catalog : 1 Schema : 1 Checks run against database jdbc:h2:tcp://localhost:9090/mem:dev: Check Table Column Count Liquibase command 'checks run' was executed successfully.