• Task
  • Version · 6.0
  • Deliver

Customize a Policy check

Last updated: August 11, 2026

Some default Policy Checks have customization options that allow you to adjust the parameters used to determine whether a changeset meets the criteria of the check. You can adjust these parameters using the checks copy or checks customize command.

Procedure

In this example we will create a check that finds table truncation statements in a sample changelog by generating a copy of the SqlUserDefinedPatternCheck check.

1

Run this command in the CLI to create a copy of the check.

In the CLI, run this command:

liquibase checks copy --check-name=SqlUserDefinedPatternCheck
2

Initiate the customization process

liquibase checks customize --check-name=CustomCheckTemplate

The CLI prompts you to finish configuring your file. A message displays:

This check cannot be customized directly because one or more fields does not have a default value.

Liquibase will then create a copy ofCustomCheckTemplateand initiate the customization workflow.

3

Provide a search string for the policy check to search for.

In this example, we will useTRUNCATEbecause this check will search the database or changelog for theTRUNCATElabel. Set 'SEARCH_STRING' (current: 'null'): (?i)^(\s*)(TRUNCATE)

4

Provide a message for your check

This message should indicate that the check you are creating is triggered. You can type custom values, or press the Enter/Return key to use the default values.

CLI message:

Set 'MESSAGE' (current: 'A match for regular expression <SEARCH_STRING> was detected in Changeset <CHANGESET>.') (default "A match for regular expression <SEARCH_STRING> was detected in Changeset <CHANGESET>."):

In this example, we will use this as our message:

Table truncation detected. Review this changeset to ensure data is not unintentionally deleted.

5

The CLI will prompt you to review the table to confirm the customization

Customization complete. Review the table below to confirm your changes.

After you complete these tasks, the checks configuration displays for your review.

6

Add the following to the changelog.sql file and save your changes:

--changeset other.dev:4 labels:v0 context:all
truncate person;
7

Execute the checks run command

liquibase checks run

Results

The new check indicates that there is an issue with your new changeset:

Checks completed validation of the changelog and found the following issues: Changeset ID: 5 Changeset Filepath: changelog.sql Check Name: Check for specific patterns in sql (SqlUserDefinedPatternCheck) Message: Table truncation detected. Review this changeset to ensure data is not unintentionally deleted.

With this knowledge provided by the customized policy check, you can investigate the table truncation and resolve it before proceeding with any deployments to the database.

PreviousBest practices when using native executorsNextConfigure policy checks