• Task
  • Version · 6.0
  • Govern

Automatically create a snapshot and run checks

Last updated: September 29, 2026

Before you begin

  • A database and a reference database you can connect to.

  • A Liquibase Secure license.

  • At least one database-scoped check enabled in your checks settings file.

Procedure

1

Set the url and referenceUrl in liquibase.properties

Replace both URLs with your database and reference database JDBC URLs.
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 checks with database scope

liquibase checks run --checks-scope=database

--checks-scope=changelog example

Executing Policy Checks against example-changelog.sql Executing all changelog checks because a valid license key was found! CHANGELOG CHECKS ---------------- Checks completed validation of the changelog and found the following issues: Check Name: Warn on Detection of 'GRANT' Statements (SqlGrantWarn) Changeset ID: 6 Changeset Filepath: example-changelog.sql: Line 42 Match: grant select on person to public; Check Severity: INFO (Return code: 0) Message: A statement granting privileges to a role or user was detected in your changelog. To prevent unintended access to the database or data it is recommended that the granting and revocation of privileges be carefully reviewed. Liquibase command 'checks run' was executed successfully.

--checks-scope=database example

Executing Policy Checks against database jdbc:h2:tcp://localhost:9090/mem:dev Executing all database checks because a valid license key was found! Database objects Validated: Catalog : 1 Schema : 1 To increase details set the --verbose property Checks run against database jdbc:h2:tcp://localhost:9090/mem:dev: Check Table Column Count (Short names: TableColumnLimit) Table must have an index (Short names: CheckTablesForIndex) Liquibase command 'checks run' was executed successfully.