sql-show-sql-warnings

--sql-show-sql-warnings is a global Boolean parameter that specifies whether Liquibase logs should include Java SQLWarning messages. The default value is true. This parameter is available in Liquibase 4.25.0 and later.

Uses

If your database connection, JDBC driver, database tables, or SQL queries contain non-fatal errors, the SQLWarning Java class may throw an exception to inform you of the issue. By default, Liquibase 4.25.0+ includes these warning messages in your Liquibase logs, including Structured Logging output.

If you know about these errors and don't want to include them in your logs, you can set --sql-show-sql-warnings to false.

Syntax

You can set this parameter in the following ways:

Option Syntax
Liquibase properties file 
liquibase.sql.showSqlWarnings: <true|false>
Global flow file argument (example) 
stages:
  Default:
    actions:
      - type: liquibase
        command: update
        globalArgs: { sql-show-sql-warnings: "<true|false>" }
Global CLI parameter 
liquibase
 --sql-show-sql-warnings=<true|false> update
 --changelog-file=example-changelog.xml

JVM system property (JAVA_OPTS Environment Variable)

 
JAVA_OPTS=-Dliquibase.sql.showSqlWarnings=<true|false>
Liquibase Environment Variables 
LIQUIBASE_SQL_SHOW_SQL_WARNINGS=<true|false>

For more information, see Working with Command Parameters.

Related links