What are parameters?
Last updated: May 1, 2026
Parameters allow you to specify additional behavior when running Liquibase Commands. They may take Booleans, strings, integers, or other types as values. You can:
- Enter properties as command-line arguments - Create connection profiles or specify other parameters in the Liquibase properties file - Specify global or command arguments in Liquibase flow file actions - Use the JAVA_OPTS variable to pass custom settings to the Java Virtual Machine (JVM) that runs Liquibase - Use environment variables to securely pass sensitive data
Configuration hierarchy
Liquibase supports the setting of properties from the following locations, from highest to lowest priority:
Liquibase flow file stage parameters
Liquibase flow file global parameters
Command-line arguments
ServletConfiginitialization parametersServletContextinitialization parametersJava system properties
OS environment variables
Configuration data, such as piped standard input, defaults files, and connection profiles and other properties stored in the Liquibase properties file.
For example, command-line arguments override ServletConfig and ServletContext initialization parameters, Java system properties, OS environment variables, and configuration data, while OS environment variables override configuration data only.
The following tables describe the Liquibase parameters that are available as global or command-specific options. For more information, run liquibase --help from the command prompt. To learn how to use parameters in more detail, see Working with Command Parameters.
Global
You can use global parameters with any Liquibase command.
Note: Syntax for each parameter is specified in kebab-case (CLI and flow file), camelCase (properties file and JAVA_OPTS), and MACRO_CASE (environment variable).
For best results, specify all commands and parameters in the --kebab-case format in the CLI. If your preference is camelCase, it also works in the CLI.
Global parameter options
Syntax ( | Type | Description |
--allow-duplicated-changeset-identifiers globalArgs: {allow-duplicated-changeset-identifiers: "val"} liquibase.allowDuplicatedChangesetIdentifiers LIQUIBASE_ALLOW_DUPLICATED_CHANGESET_IDENTIFIERS | Boolean | Specifies whether Liquibase lets you deploy multiple changesets with the same filepath, author, and ID. Liquibase 4.25.1+. Default: |
--always-drop-instead-of-replace globalArgs: {always-drop-instead-of-replace: "val"} liquibase.alwaysDropInsteadOfReplace LIQUIBASE_ALWAYS_DROP_INSTEAD_OF_REPLACE | Boolean | If Default: |
--always-override-stored-logic-schema globalArgs: {always-override-stored-logic-schema: "val"} liquibase.alwaysOverrideStoredLogicSchema LIQUIBASE_ALWAYS_OVERRIDE_STORED_LOGIC_SCHEMA | String | When generating SQL for Default: |
--analytics-enabled globalArgs: {analytics-enabled: "val"} liquibase.analyticsEnabled LIQUIBASE_ANALYTICS_ENABLED | Boolean | Liquibase 4.30.0+. Enables or disables Liquibase Anonymous Analytics. Default: |
--analytics-log-level globalArgs: {analytics-log-level: "val"} liquibase.analyticsLogLevel LIQUIBASE_ANALYTICS_LOG_LEVEL | String | Liquibase 4.30.0+. Specifies the amount of detail Liquibase provides in user-facing logs for Anonymous Analytics. Default: |
--auto-reorg globalArgs: {auto-reorg: "val"} liquibase.autoReorg LIQUIBASE_AUTO_REORG | Boolean | Defines whether Liquibase automatically reorganizes table objects stored on disk when you modify a DB2 database. Default: |
--changelog-lock-poll-rate globalArgs: {changelog-lock-poll-rate: "val"} liquibase.changelogLockPollRate LIQUIBASE_CHANGELOG_LOCK_POLL_RATE | Integer | Specifies the number of seconds Liquibase waits to check if a changelog lock has been released. Default: |
--changelog-lock-wait-time-in-minutes globalArgs: {changelog-lock-wait-time-in-minutes: "val"} liquibase.changelogLockWaitTimeInMinutes LIQUIBASE_CHANGELOG_LOCK_WAIT_TIME_IN_MINUTES | Integer | Specifies the amount of time Liquibase waits for a locked database to become available. Default: |
--changelog-parse-mode globalArgs: {changelog-parse-mode: "val"} liquibase.changelogParseMode LIQUIBASE_CHANGELOG_PARSE_MODE | String | Configures how to handle unknown fields in changelog files. Possible values:
Default: |
--classpath globalArgs: {classpath: "val"} liquibase.classpath LIQUIBASE_CLASSPATH | String | Specifies additional classpath entries to use. Use the format Note: Liquibase uses the classpath to find all JARs in any location you specify except for extension JARs, such as the Liquibase extension for DynamoDB. Extension JARs included via classpath must go in one of the following locations: |
--convert-data-types globalArgs: {convert-data-types: "val"} liquibase.convertDataTypes LIQUIBASE_CONVERT_DATA_TYPES | Boolean | Allows Liquibase to convert data types such as Default: |
--database-changelog-lock-table-name globalArgs: {database-changelog-lock-table-name: "val"} liquibase.databaseChangelogLockTableName LIQUIBASE_DATABASE_CHANGELOG_LOCK_TABLE_NAME | String | Specifies the name of a table to use for tracking concurrent Liquibase usage. Default: |
--database-changelog-table-name globalArgs: {database-changelog-table-name: "val"} liquibase.databaseChangelogTableName LIQUIBASE_DATABASE_CHANGELOG_TABLE_NAME | String | Specifies the name of a table to use for tracking change history. Default: |
--database-class globalArgs: {database-class: "val"} liquibase.databaseClass LIQUIBASE_DATABASE_CLASS | String | Specifies the class to use for a Database implementation. See database-class. |
--ddl-lock-timeout globalArgs: {ddl-lock-timeout: "val"} liquibase.ddlLockTimeout LIQUIBASE_DDL_LOCK_TIMEOUT | Integer | Liquibase 4.6.2+. Indicates the number of seconds a DDL command should wait for the locks to become available before throwing the "resource busy" error message. This parameter applies only to Oracle databases. See ddl-lock-timeout. |
--defaults-file globalArgs: {defaults-file: "val"} liquibase.defaultsFile LIQUIBASE_DEFAULTS_FILE | String | Specifies the file with default Liquibase properties. Default: |
--diff-column-order globalArgs: {diff-column-order: "val"} liquibase.diffColumnOrder LIQUIBASE_DIFF_COLUMN_ORDER | Boolean | Defines whether Liquibase compares the column order in a diff operation. Default: |
--driver globalArgs: {driver: "val"} liquibase.driver LIQUIBASE_DRIVER | String | Specifies the database driver class. See driver. |
--driver-properties-file globalArgs: {driver-properties-file: "val"} liquibase.driverPropertiesFile LIQUIBASE_DRIVER_PROPERTIES_FILE | String | Specifies a file with driver-specific JDBC connection properties, to keep them separate from other properties. See driver-properties-file. |
--duplicate-file-mode globalArgs: {duplicate-file-mode: "val"} liquibase.duplicateFileMode LIQUIBASE_DUPLICATE_FILE_MODE | String | How to handle multiple files being found in the search path that have duplicate paths. Valid values are Default: |
--error-on-circular-include-all globalArgs: {error-on-circular-include-all: "val"} liquibase.errorOnCircularIncludeAll LIQUIBASE_ERROR_ON_CIRCULAR_INCLUDE_ALL | Boolean | Throw an error if Liquibase detects that an includeAll will cause a circular reference (and thus a changelog parse error). Default: |
--file-encoding globalArgs: {file-encoding: "val"} liquibase.fileEncoding LIQUIBASE_FILE_ENCODING | String | Encoding to use when reading files. Valid values include:
Default: |
--generate-changeset-created-values globalArgs: {generate-changeset-created-values: "val"} liquibase.generateChangesetCreatedValues LIQUIBASE_GENERATE_CHANGESET_CREATED_VALUES | Boolean | Determines whether Liquibase adds timestamps to changesets in the changelog it generates when you run the Default: |
--generated-changeset-ids-contains-description globalArgs: {generated-changeset-ids-contains-description: "val"} liquibase.generatedChangesetIdsContainsDescription LIQUIBASE_GENERATED_CHANGESET_IDS_CONTAINS_DESCRIPTION | String | Determines whether Liquibase includes changeset descriptions in changelogs generated with the Default: |
--headless globalArgs: {headless: "val"} liquibase.headless LIQUIBASE_HEADLESS | String | Forces Liquibase to run without access to the console for input and output. Default: |
--include-catalog-in-specification globalArgs: {include-catalog-in-specification: "val"} liquibase.includeCatalogInSpecification LIQUIBASE_INCLUDE_CATALOG_IN_SPECIFICATION | Boolean | Defines whether Liquibase includes the catalog name when determining equality between the compared databases. Default: |
--include-relations-for-computed-columns globalArgs: {include-relations-for-computed-columns: "val"} liquibase.includeRelationsForComputedColumns LIQUIBASE_INCLUDE_RELATIONS_FOR_COMPUTED_COLUMNS | Boolean | Specifies whether Liquibase commands like |
--include-system-classpath globalArgs: {include-system-classpath: "val"} liquibase.includeSystemClasspath LIQUIBASE_INCLUDE_SYSTEM_CLASSPATH | Boolean | Defines whether Liquibase includes the system classpath when resolving classes at runtime. Default: |
--license-key globalArgs: {license-key: "val"} liquibase.licenseKey LIQUIBASE_LICENSE_KEY | String | Specifies Liquibase Secure license key that allows using all the functionality of Liquibase Open Source and Liquibase Secure. Deprecated: |
--liquibase-catalog-name globalArgs: {liquibase-catalog-name: "val"} liquibase.liquibaseCatalogName LIQUIBASE_LIQUIBASE_CATALOG_NAME | String | Specifies the catalog to use for Liquibase objects. See liquibase-catalog-name. |
--liquibase-schema-name globalArgs: {liquibase-schema-name: "val"} liquibase.liquibaseSchemaName LIQUIBASE_LIQUIBASE_SCHEMA_NAME | String | Specifies the schema to use for the creation of Liquibase objects, like the DATABASECHANGELOG and DATABASECHANGELOGLOCK tracking tables. See liquibase-schema-name. |
--liquibase-tablespace-name globalArgs: {liquibase-tablespace-name: "val"} liquibase.liquibaseTablespaceName LIQUIBASE_LIQUIBASE_TABLESPACE_NAME | String | Specifies the tablespace Liquibase uses to store objects that are being deployed to your database. See liquibase-tablespace-name. |
--log-channels globalArgs: {log-channels: "val"} liquibase.logChannels LIQUIBASE_LOG_CHANNELS | String | Controls which log channels have their level set by the Example:
|
--log-file globalArgs: {log-file: "val"} liquibase.logFile LIQUIBASE_LOG_FILE | String | Sends logging messages of what Liquibase does during runtime to a file. See log-file. |
--log-format globalArgs: {log-format: "val"} liquibase.logFormat LIQUIBASE_LOG_FORMAT | String | Sets the format of log output to the console or to log files. Liquibase Open Source users default to unstructured |
--log-level globalArgs: {log-level: "val"} liquibase.logLevel LIQUIBASE_LOG_LEVEL | String | Controls the amount of messages that are generated when running Liquibase commands. The official log levels are: Default: |
--mirror-console-messages-to-log globalArgs: {mirror-console-messages-to-log: "val"} liquibase.mirrorConsoleMessagesToLog LIQUIBASE_MIRROR_CONSOLE_MESSAGES_TO_LOG | Boolean | When set to Default: |
--mirror-output-to-console globalArgs: {mirror-output-to-console: "val"} liquibase.mirrorOutputToConsole LIQUIBASE_MIRROR_OUTPUT_TO_CONSOLE | Boolean | Liquibase Secure 4.28.0+. When set to Default: |
--missing-property-mode globalArgs: {missing-property-mode: "val"} liquibase.missingPropertyMode LIQUIBASE_MISSING_PROPERTY_MODE | String | Specifies how to handle changelog property expressions where a value is not set. For example, a string Default: |
--monitor-performance globalArgs: {monitor-performance: "val"} liquibase.monitorPerformance LIQUIBASE_MONITOR_PERFORMANCE | Boolean | Enables performance tracking. If Default: |
--on-missing-include-changelog globalArgs: {on-missing-include-changelog: "val"} liquibase.onMissingIncludeChangelog LIQUIBASE_ON_MISSING_INCLUDE_CHANGELOG | String | Controls how Liquibase behaves when it cannot find a changelog specified in an |
--output-file globalArgs: {output-file: "val"} liquibase.outputFile LIQUIBASE_OUTPUT_FILE | String | File path to where the command output will be written. If not specified, output goes to |
--output-file-encoding globalArgs: {output-file-encoding: "val"} liquibase.outputFileEncoding LIQUIBASE_OUTPUT_FILE_ENCODING | String | Determines which character encoding to use when writing Liquibase command outputs to external files. Default: |
--output-line-separator globalArgs: {output-line-separator: "val"} liquibase.outputLineSeparator LIQUIBASE_OUTPUT_LINE_SEPARATOR | String | Specifies the string that separates lines in Default: OS default line separator ( |
--preserve-classpath-prefix-in-normalized-paths globalArgs: {preserve-classpath-prefix-in-normalized-paths: "val"} liquibase.preserveClasspathPrefixInNormalizedPaths LIQUIBASE_PRESERVE_CLASSPATH_PREFIX_IN_NORMALIZED_PATHS | Boolean | Liquibase 4.30.0+. Forces Liquibase to preserve the prefix Default: |
--preserve-schema-case globalArgs: {preserve-schema-case: "val"} liquibase.preserveSchemaCase LIQUIBASE_PRESERVE_SCHEMA_CASE | Boolean | Liquibase 4.12.0+. Determines whether Liquibase treats schema and catalog names as case-sensitive. If If Default: |
--secure-global-end-delimiter globalArgs: {secure-global-end-delimiter: "val"} liquibase.secure.globalEndDelimiter LIQUIBASE_PRO_GLOBAL_END_DELIMITER | String | Liquibase 4.25.1+. Specifies a default delimiter for all changesets. Default: It is a best practice not to use |
--secure-global-end-delimiter-prioritized globalArgs: {secure-global-end-delimiter-prioritized: "val"} liquibase.secure.globalEndDelimiter.prioritized LIQUIBASE_PRO_GLOBAL_END_DELIMITER_PRIORITIZED | Boolean | Liquibase 4.25.1+. Specifies whether the |
--secure-global-strip-comments globalArgs: {secure-global-strip-comments: "val"} liquibase.secure.globalStripComments LIQUIBASE_PRO_GLOBAL_STRIP_COMMENTS | Boolean | Liquibase 4.29.2+. Specifies default SQL comment stripping behavior for all changesets. Default: |
--secure-global-strip-comments-prioritized globalArgs: {secure-global-strip-comments-prioritized: "val"} liquibase.secure.globalStripComments.prioritized LIQUIBASE_PRO_GLOBAL_STRIP_COMMENTS_PRIORITIZED | Boolean | Liquibase 4.29.2+. Specifies whether the Default: |
--secure-mark-unused-not-drop globalArgs: {secure-mark-unused-not-drop: "val"} liquibase.secure.markUnusedNotDrop LIQUIBASE_PRO_MARK_UNUSED_NOT_DROP | Boolean | Defines whether a column will be dropped when running If If Default: |
--secure-sql-inline globalArgs: {secure-sql-inline: "val"} liquibase.secure.sql.inline LIQUIBASE_PRO_SQL_INLINE | Boolean | If Default: |
--secure-strict globalArgs: {secure-strict: "val"} liquibase.proStrict LIQUIBASE_PRO_STRICT | Boolean | If Default: |
--secure-synonyms-drop-public globalArgs: {secure-synonyms-drop-public: "val"} liquibase.secure.synonyms.drop.public LIQUIBASE_PRO_SYNONYMS_DROP_PUBLIC | Boolean | If Default: |
--prompt-for-non-local-database globalArgs: {prompt-for-non-local-database: "val"} liquibase.promptForNonLocalDatabase LIQUIBASE_PROMPT_FOR_NON_LOCAL_DATABASE | Boolean | Determines whether Liquibase prompts you if you access a non-local database. Default: |
--property-provider-class globalArgs: {property-provider-class: "val"} liquibase.propertyProviderClass LIQUIBASE_PROPERTY_PROVIDER_CLASS | String | Implements the |
--search-path globalArgs: {search-path: "val"} liquibase.searchPath LIQUIBASE_SEARCH_PATH | String | Specifies the locations to search for migration files in. Separate multiple paths with commas. See search-path. |
--secure-parsing globalArgs: {secure-parsing: "val"} liquibase.secureParsing LIQUIBASE_SECURE_PARSING | Boolean | Enables the validation of the custom XSD files. If Default: |
--should-run globalArgs: {should-run: "val"} liquibase.shouldRun LIQUIBASE_SHOULD_RUN | Boolean | Determines whether Liquibase commands execute. Default: |
--should-snapshot-data globalArgs: {should-snapshot-data: "val"} liquibase.shouldSnapshotData LIQUIBASE_SHOULD_SNAPSHOT_DATA | Boolean | Determines whether Liquibase snapshots your database data. Default: |
--show-banner globalArgs: {show-banner: "val"} liquibase.showBanner LIQUIBASE_SHOW_BANNER | Boolean | If Default: |
--sql-log-level globalArgs: {sql-log-level: "val"} liquibase.sql.logLevel LIQUIBASE_SQL_LOG_LEVEL | String | Defines the level of logging for SQL statements. Valid values are
Default: |
--sql-show-sql-warnings globalArgs: {sql-show-sql-warnings: "val"} liquibase.sql.showSqlWarnings LIQUIBASE_SQL_SHOW_SQL_WARNINGS | Boolean | Specifies whether Liquibase logs should include Java Default: |
--strict globalArgs: {strict: "val"} liquibase.strict LIQUIBASE_STRICT | Boolean | If Default: |
--support-property-escaping globalArgs: {support-property-escaping: "val"} liquibase.supportPropertyEscaping LIQUIBASE_SUPPORT_PROPERTY_ESCAPING | Boolean | If Default: |
--supports-method-validation-level globalArgs: {supports-method-validation-level: "val"} liquibase.supportsMethodValidationLevel LIQUIBASE_SUPPORTS_METHOD_VALIDATION_LEVEL | String | Liquibase 4.29.0+ . Controls the level of validation to check if a change's Default: |
--suppress-liquibase-sql globalArgs: {suppress-liquibase-sql: "val"} liquibase.suppressLiquibaseSql LIQUIBASE_SUPPRESS_LIQUIBASE_SQL | Boolean | Liquibase 4.29.2+. When set to Default: |
--trim-load-data-file-header globalArgs: {trim-load-data-file-header: "val"} liquibase.trimLoadDataFileHeader LIQUIBASE_TRIM_LOAD_DATA_FILE_HEADER | Boolean | Liquibase 4.29.0+. Trims whitespace from CSV headers that you call with the Default: |
--ui-service globalArgs: {ui-service: "val"} liquibase.uiService LIQUIBASE_UI_SERVICE | String | Specifies the default UI service logger used by Liquibase. Valid values are Default: |
--use-procedure-schema globalArgs: {use-procedure-schema: "val"} liquibase.useProcedureSchema LIQUIBASE_USE_PROCEDURE_SCHEMA | Boolean | If Default: |
--validate-xml-changelog-files globalArgs: {validate-xml-changelog-files: "val"} liquibase.validateXmlChangelogFiles LIQUIBASE_VALIDATE_XML_CHANGELOG_FILES | Boolean | If Default: |
For more information, see DATABASECHANGELOGHISTORY table and dbcl-history.
Parameter | Typ | Definition |
--dbclhistory-capture-extensions globalArgs: {dbclhistory-capture-extensions: "val"} liquibase.dbclhistory.captureExtensions LIQUIBASE_DBCLHISTORY_CAPTURE_EXTENSIONS | Boolean | If |
--dbclhistory-capture-sql globalArgs: {dbclhistory-capture-sql: "val"} liquibase.dbclhistory.captureSql LIQUIBASE_DBCLHISTORY_CAPTURE_SQL | Boolean | If |
--dbclhistory-enabled globalArgs: {dbclhistory-enabled: "val"} liquibase.dbclhistory.enabled LIQUIBASE_DBCLHISTORY_ENABLED | Boolean | Enables the DATABASECHANGELOGHISTORY table. This table includes records of rollbacks, dropAlls, and repeated runOnChange type activity, which is not available in the standard DATABASECHANGELOG table. Liquibase 4.27.0+. Default: |
--dbclhistory-severity globalArgs: {dbclhistory-severity: "val"} liquibase.dbclhistory.severity LIQUIBASE_DBCLHISTORY_SEVERITY | String | The exit code for Liquibase to return if an exception is encountered while recording events to the DATABASECHANGELOGHISTORY table. Valid values are |
For more information, see runWith.
Syntax ( | Type | Description |
--psql-args globalArgs: {psql-args: "val"} liquibase.psql.args LIQUIBASE_PSQL_ARGS | String | Defines extra arguments to pass to the Note: The delimiter for arguments is a space |
--psql-keep-temp globalArgs: {psql-keep-temp: "val"} liquibase.psql.keep.temp LIQUIBASE_PSQL_KEEP_TEMP | Boolean | Indicates whether or not to keep a temporary SQL file after the execution of PSQL. If |
--psql-keep-temp-name globalArgs: {psql-keep-temp-name: "val"} liquibase.psql.keep.temp.name LIQUIBASE_PSQL_KEEP_TEMP_NAME | String | Indicates the name of a temporary SQL file after the execution of PSQL. If no file name is specified, a name is automatically generated. |
--psql-keep-temp-path globalArgs: {psql-keep-temp-path: "val"} liquibase.psql.keep.temp.path LIQUIBASE_PSQL_KEEP_TEMP_PATH | String | Specify the path in which to store the temporary files after the execution of PSQL. If not specified, the files will be stored in the system's |
--psql-log-file globalArgs: {psql-log-file: "val"} liquibase.psql.logFile LIQUIBASE_PSQL_LOG_FILE | String | Log file for PSQLoutput. |
--psql-path globalArgs: {psql-path: "val"} liquibase.psql.path LIQUIBASE_PSQL_PATH | String | Path to Linux:
Windows:
|
--psql-timeout globalArgs: {psql-timeout: "val"} liquibase.psql.timeout LIQUIBASE_PSQL_TIMEOUT | Integer | Indicates seconds to wait for the |
--sqlcmd-args globalArgs: {sqlcmd-args: "val"} liquibase.sqlcmd.args LIQUIBASE_SQLCMD_ARGS | String | Defines extra arguments to pass to the Note: The delimiter for arguments is a space |
--sqlcmd-catalog-name globalArgs: {sqlcmd-catalog-name: "val"} liquibase.sqlcmd.catalogName LIQUIBASE_SQLCMD_CATALOG_NAME | String | Database to use when running SQLCMD. |
--sqlcmd-keep-temp globalArgs: {sqlcmd-keep-temp: "val"} liquibase.sqlcmd.keep.temp LIQUIBASE_SQLCMD_KEEP_TEMP | Boolean | Indicates whether or not to keep a temporary SQL file after the execution of SQLCMD. If |
--sqlcmd-keep-temp-name globalArgs: {sqlcmd-keep-temp-name: "val"} liquibase.sqlcmd.keep.temp.name LIQUIBASE_SQLCMD_KEEP_TEMP_NAME | String | Indicates the name of a temporary SQL file after the execution of SQLCMD. If no file name is specified, a name is automatically generated. |
--sqlcmd-keep-temp-overwrite globalArgs: {sqlcmd-keep-temp-overwrite: "val"} liquibase.sqlcmd.keep.temp.overwrite LIQUIBASE_SQLCMD_KEEP_TEMP_OVERWRITE | Boolean | Overwrites any files in the specified directory with the same name. Default: |
--sqlcmd-keep-temp-path globalArgs: {sqlcmd-keep-temp-path: "val"} liquibase.sqlcmd.keep.temp.path LIQUIBASE_SQLCMD_KEEP_TEMP_PATH | String | Specify the path in which to store the temporary files after the execution of SQLCMD. If not specified, the files will be stored in the system's |
--sqlcmd-log-file globalArgs: {sqlcmd-log-file: "val"} liquibase.sqlcmd.logFile LIQUIBASE_SQLCMD_LOG_FILE | String | Log file for SQLCMDoutput. |
--sqlcmd-path globalArgs: {sqlcmd-path: "val"} liquibase.sqlcmd.path LIQUIBASE_SQLCMD_PATH | String | Path to Linux:
Windows:
|
--sqlcmd-timeout globalArgs: {sqlcmd-timeout: "val"} liquibase.sqlcmd.timeout LIQUIBASE_SQLCMD_TIMEOUT | Integer | Indicates seconds to wait for the |
--sqlplus-args globalArgs: {sqlplus-args: "val"} liquibase.sqlplus.args LIQUIBASE_SQLPLUS_ARGS | String | Defines extra arguments to pass to the Note: The delimiter for arguments is a space |
--sqlplus-create-spool globalArgs: {sqlplus-create-spool: "val"} liquibase.sqlplus.createSpool LIQUIBASE_SQLPLUS_CREATE_SPOOL | Boolean | If |
--sqlplus-keep-temp globalArgs: {sqlplus-keep-temp: "val"} liquibase.sqlplus.keep.temp LIQUIBASE_SQLPLUS_KEEP_TEMP | Boolean | Indicates whether or not to keep a temporary SQL file after the execution of SQL Plus. If |
--sqlplus-keep-temp-name globalArgs: {sqlplus-keep-temp-name: "val"} liquibase.sqlplus.keep.temp.name LIQUIBASE_SQLPLUS_KEEP_TEMP_NAME | String | Indicates the name of a temporary SQL file after the execution of SQL Plus. If no file name is specified, a name is automatically generated. In Oracle, if no file extension is specified, the file is saved as |
--sqlplus-keep-temp-overwrite globalArgs: {sqlplus-keep-temp-overwrite: "val"} liquibase.sqlplus.keep.temp.overwrite LIQUIBASE_SQLPLUS_KEEP_TEMP_OVERWRITE | Boolean | Overwrites any files in the specified directory with the same name. Default: |
--sqlplus-keep-temp-path globalArgs: {sqlplus-keep-temp-path: "val"} liquibase.sqlplus.keep.temp.path LIQUIBASE_SQLPLUS_KEEP_TEMP_PATH | String | Specify the path in which to store the temporary files after the execution of SQL Plus. If not specified, the files will be stored in the system's |
--sqlplus-password globalArgs: {sqlplus-password: "val"} liquibase.sqlplus.password LIQUIBASE_SQLPLUS_PASSWORD | String | Liquibase 4.29.2+. Password to use with the native executor, such as the password for an account with SYSDBA privileges. Liquibase will attempt to use the password exactly as entered. |
--sqlplus-path globalArgs: {sqlplus-path: "val"} liquibase.sqlplus.path LIQUIBASE_SQLPLUS_PATH | String | Path to Linux:
or
Windows:
|
--sqlplus-sqlerror globalArgs: {sqlplus-sqlerror: "val"} liquibase.sqlplus.sqlerror LIQUIBASE_SQLPLUS_SQLERROR | String | Control the outcome when Liquibase returns a SQL error. The error clause is passed directly to Oracle. Default:
|
--sqlplus-timeout globalArgs: {sqlplus-timeout: "val"} liquibase.sqlplus.timeout LIQUIBASE_SQLPLUS_TIMEOUT | Integer | Indicates seconds to wait for the |
--sqlplus-username globalArgs: {sqlplus-username: "val"} liquibase.sqlplus.username LIQUIBASE_SQLPLUS_USERNAME | String | Liquibase 4.29.2+. Username to use with the native executor, such as |
Operation Reports
For more information, see Operation Reports.
Syntax ( | Type | Description | Requirement |
--reports-enabled globalArgs: {reports-enabled: "val"} liquibase.reports.enabled LIQUIBASE_REPORTS_ENABLED | Boolean | Enables or disables all reports at the global level. Overridden by | Required (either this or |
--reports-name globalArgs: {reports-name: "val"} liquibase.reports.name LIQUIBASE_REPORTS_NAME | String | Specifies the name of the report file at the global level. Overridden by | Optional |
--reports-open globalArgs: {reports-open: "val"} liquibase.reports.open LIQUIBASE_REPORTS_OPEN | Boolean | Specifies whether to automatically open the report in your default browser at the global level. Overridden by | Optional |
--reports-path globalArgs: {reports-path: "val"} liquibase.reports.path LIQUIBASE_REPORTS_PATH | String | Specifies the file path to the report file at the global level. Overridden by | Optional |
--reports-suppress-exception globalArgs: {reports-suppress-exception: "val"} liquibase.reports.suppressException LIQUIBASE_REPORTS_SUPPRESS_EXCEPTION | Boolean | Liquibase 4.31.0+. Specifies whether to hide exceptions (which may contain SQL) from operation reports at the global level. Overridden by If If | Optional |
--reports-suppress-sql globalArgs: {reports-suppress-sql: "val"} liquibase.reports.suppressSql LIQUIBASE_REPORTS_SUPPRESS_SQL | Boolean | Liquibase 4.31.0+. Specifies whether to hide changeset SQL in operation reports at the global level. Overridden by | Optional |
For more information, see Structured Logging and Custom and Private Data in Structured Logs.
Syntax ( | Type | Description |
--custom-log-data-file cmdArgs: {custom-log-data-file: "val"} liquibase.customLogDataFile LIQUIBASE_CUSTOM_LOG_DATA_FILE | String | Specifies the file that contains the custom data that can be included or excluded from Structured Logs. Available in Liquibase 4.23.2+. See custom-log-data-file. |
--custom-log-data-frequency cmdArgs: {custom-log-data-frequency: "val"} liquibase.customLogDataFrequency LIQUIBASE_CUSTOM_LOG_DATA_FREQUENCY | String | Specifies the frequency that custom log data will be included in Structured Logs. Valid values are: |
For more information, see Policy Checks and Liquibase Secure Custom Policy Checks.
Syntax ( | Type | Description |
--script-python-executable-path cmdArgs: {script-python-executable-path: "val"} liquibase.script.python.executablePath LIQUIBASE_SCRIPT_PYTHON_EXECUTABLE_PATH Read more: | String | Specifies the path Liquibase uses to run the Python executable associated with a virtual environment. For more information, see Create a Python Virtual Environment. |
For more information, see Liquibase Parameters for Amazon DynamoDB Secure and Liquibase Amazon DynamoDB Secure Extension Overview.
Name ( | Type | Description |
--dynamodb-tracking-tables-billing-mode globalArgs: {dynamodb-tracking-tables-billing-mode: "val"} liquibase.dynamodb.trackingTables.billingMode LIQUIBASE_DYNAMODB_TRACKING_TABLES_BILLING_MODE Read more: | String | Initial billing mode for Liquibase tracking tables (DBCL and DBCLL). This controls how you pay for database read/write operations and capacity. Valid values: Note: If you want to change the billing mode of the tracking tables after you create them, you must instead use the |
--dynamodb-tracking-tables-provisioned-throughput-read-capacity-units globalArgs: {dynamodb-tracking-tables-provisioned-throughput-read-capacity-units: "val"} liquibase.dynamodb.trackingTables.provisionedThroughput.readCapacityUnits LIQUIBASE_DYNAMODB_TRACKING_TABLES_PROVISIONED_THROUGHPUT_READ_CAPACITY_UNITS Read more: | Integer | Specifies how many Note: If you want to change the provisioned throughput values of the tracking tables after you create them, you must instead use the |
--dynamodb-tracking-tables-provisioned-throughput-write-capacity-units globalArgs: {dynamodb-tracking-tables-provisioned-throughput-write-capacity-units: "val"} liquibase.dynamodb.trackingTables.provisionedThroughput.writeCapacityUnits LIQUIBASE_DYNAMODB_TRACKING_TABLES_PROVISIONED_THROUGHPUT_WRITE_CAPACITY_UNITS Read more: | Integer | Specifies how many Note: If you want to change the provisioned throughput values of the tracking tables after you create them, you must instead use the |
--dynamodb-waiters-enabled globalArgs: {dynamodb-waiters-enabled: "val"} liquibase.dynamodb.waiters.enabled LIQUIBASE_DYNAMODB_WAITERS_ENABLED Read more: | Boolean | Specifies whether to enable or disable the Warning: If you set this parameter to |
--dynamodb-waiters-fail-on-timeout globalArgs: {dynamodb-waiters-fail-on-timeout: "val"} liquibase.dynamodb.waiters.failOnTimeout LIQUIBASE_DYNAMODB_WAITERS_FAIL_ON_TIMEOUT Read more: | Boolean | Specifies whether Liquibase fails if the |
--dynamodb-waiters-log-notification-enabled globalArgs: {dynamodb-waiters-log-notification-enabled: "val"} liquibase.dynamodb.waiters.log.notification.enabled LIQUIBASE_DYNAMODB_WAITERS_LOG_NOTIFICATION_ENABLED Read more: | Boolean | Specifies whether Liquibase sends you periodic status notifications while the |
--dynamodb-waiters-log-notification-interval globalArgs: {dynamodb-waiters-log-notification-interval: "val"} liquibase.dynamodb.waiters.log.notification.interval LIQUIBASE_DYNAMODB_WAITERS_LOG_NOTIFICATION_INTERVAL Read more: | Integer | Specifies the interval in milliseconds for Liquibase to wait between sending status notifications while the |
--dynamodb-waiter-create-fixed-delay-backoff-strategy-duration globalArgs: {dynamodb-waiter-create-fixed-delay-backoff-strategy-duration: "val"} liquibase.dynamodb.waiter.create.fixedDelayBackoffStrategy.duration LIQUIBASE_DYNAMODB_WAITER_CREATE_FIXED_DELAY_BACKOFF_STRATEGY_DURATION Read more: | Integer | Number of seconds for the |
--dynamodb-waiter-create-max-attempts globalArgs: {dynamodb-waiter-create-max-attempts: "val"} liquibase.dynamodb.waiter.create.maxAttempts LIQUIBASE_DYNAMODB_WAITER_CREATE_MAX_ATTEMPTS Read more: | Integer | Maximum number of attempts for the |
--dynamodb-waiter-create-total-timeout globalArgs: {dynamodb-waiter-create-total-timeout: "val"} liquibase.dynamodb.waiter.create.totalTimeout LIQUIBASE_DYNAMODB_WAITER_CREATE_TOTAL_TIMEOUT Read more: | Integer | Total number of seconds for the |
--dynamodb-waiter-delete-fixed-delay-backoff-strategy-duration globalArgs: {dynamodb-waiter-delete-fixed-delay-backoff-strategy-duration: "val"} liquibase.dynamodb.waiter.delete.fixedDelayBackoffStrategy.duration LIQUIBASE_DYNAMODB_WAITER_DELETE_FIXED_DELAY_BACKOFF_STRATEGY_DURATION Read more: | Integer | Number of seconds for the |
--dynamodb-waiter-delete-max-attempts globalArgs: {dynamodb-waiter-delete-max-attempts: "val"} liquibase.dynamodb.waiter.delete.maxAttempts LIQUIBASE_DYNAMODB_WAITER_DELETE_MAX_ATTEMPTS Read more: | Integer | Maximum number of attempts for the |
--dynamodb-waiter-delete-total-timeout globalArgs: {dynamodb-waiter-delete-total-timeout: "val"} liquibase.dynamodb.waiter.delete.totalTimeout LIQUIBASE_DYNAMODB_WAITER_DELETE_TOTAL_TIMEOUT Read more: | Integer | Total number of seconds for the |
--dynamodb-waiter-update-fixed-delay-backoff-strategy-duration globalArgs: {dynamodb-waiter-update-fixed-delay-backoff-strategy-duration: "val"} liquibase.dynamodb.waiter.update.fixedDelayBackoffStrategyDuration LIQUIBASE_DYNAMODB_WAITER_UPDATE_FIXED_DELAY_BACKOFF_STRATEGY_DURATION Read more: | Integer | Number of seconds for the |
--dynamodb-waiter-update-max-attempts globalArgs: {dynamodb-waiter-update-max-attempts: "val"} liquibase.dynamodb.waiter.update.maxAttempts LIQUIBASE_DYNAMODB_WAITER_UPDATE_MAX_ATTEMPTS Read more: | Integer | Maximum number of attempts for the |
--dynamodb-waiter-update-total-timeout globalArgs: {dynamodb-waiter-update-total-timeout: "val"} liquibase.dynamodb.waiter.update.totalTimeout LIQUIBASE_DYNAMODB_WAITER_UPDATE_TOTAL_TIMEOUT Read more: | Integer | Total number of seconds for the |
For more information, see Liquibase Parameters for Databricks and Using Liquibase with Databricks Platforms.
Name ( | Type | Description |
--databricks-auth-mechanism globalArgs: {databricks-auth-mechanism: "val"} liquibase.databricks.authMechanism LIQUIBASE_DATABRICKS_AUTH_MECHANISM Read more: | String | Liquibase Secure Databricks extension 1.0.0+. Specifies the authentication mechanism for Liquibase to use with Databricks. Valid values are: |
--databricks-catalog globalArgs: {databricks-catalog: "val"} liquibase.databricks.catalog LIQUIBASE_DATABRICKS_CATALOG Read more: | String | Liquibase Secure Databricks extension 1.0.0+. Specifies the catalog for Liquibase to use with Databricks. |
--databricks-http-path globalArgs: {databricks-http-path: "val"} liquibase.databricks.httpPath LIQUIBASE_DATABRICKS_HTTP_PATH Read more: | String | Liquibase Secure Databricks extension 1.0.0+. Specifies the HTTP path of the compute resource (a Databricks cluster or a Databricks SQL warehouse) for Liquibase to use. |
--databricks-oauth-auth-flow globalArgs: {databricks-oauth-auth-flow: "val"} liquibase.databricks.oauth.authFlow LIQUIBASE_DATABRICKS_OAUTH_AUTH_FLOW Read more: | Integer | Liquibase Secure Databricks extension 1.0.0+. Specifies the OAuth2 authentication flow for the Databricks driver connection. Valid values are: |
--databricks-oauth-client-id globalArgs: {databricks-oauth-client-id: "val"} liquibase.databricks.oauth.clientId LIQUIBASE_DATABRICKS_OAUTH_CLIENT_ID Read more: | String | Liquibase Secure Databricks extension 1.0.0+. Specifies the Client ID for OAuth authentication on Databricks. The Client ID is the service principal's UUID or Application ID value. |
--databricks-oauth-client-secret globalArgs: {databricks-oauth-client-secret: "val"} liquibase.databricks.oauth.clientSecret LIQUIBASE_DATABRICKS_OAUTH_CLIENT_SECRET Read more: | String | Liquibase Secure Databricks extension 1.0.0+. Specifies the Client Secret for OAuth authentication on Databricks. The Client Secret is the service principal's OAuth Secret value. |
--databricks-schema globalArgs: {databricks-schema: "val"} liquibase.databricks.schema LIQUIBASE_DATABRICKS_SCHEMA Read more: | String | Liquibase Secure Databricks extension 1.0.0+. Specifies the schema for Liquibase to use with Databricks. |
For more information, see Liquibase Parameters for MongoDB and Using Liquibase MongoDB Secure with MongoDB platforms.
Name ( | Type | Description |
--mongodb-adjust-tracking-tables-on-startup globalArgs: {adjust-tracking-tables-on-startup: "val"} liquibase.mongodb.adjustTrackingTablesOnStartup LIQUIBASE_MONGODB_ADJUST_TRACKING_TABLES_ON_STARTUP Read more: | Boolean | Validates the Liquibase DATABASECHANGELOG and DATABASECHANGELOGLOCK collections on startup. If they are not up to date with the current release, Liquibase adjusts them. It is a best practice to keep this parameter enabled whenever you upgrade to a new Liquibase version. Default: |
--mongodb-oidc-authentication-mechanism globalArgs: {mongodb-oidc-authentication-mechanism: "val"} liquibase.mongodb.oidc.authenticationMechanism LIQUIBASE_MONGODB_OIDC_AUTHENTICATION_MECHANISM Read more: | String | Authentication mechanism for MongoDB. Valid values are: |
--mongodb-oidc-environment globalArgs: {mongodb-oidc-environment: "val"} liquibase.mongodb.oidc.environment LIQUIBASE_MONGODB_OIDC_ENVIRONMENT Read more: | String | Cloud provider environment for OIDC authentication. Valid values are: |
--mongodb-oidc-oidc-application-id-uri globalArgs: {mongodb-oidc-oidc-application-id-uri: "val"} liquibase.mongodb.oidc.oidcApplicationIDURI LIQUIBASE_MONGODB_OIDC_OIDC_APPLICATION_ID_URI Read more: | String | Application ID URI used for OIDC authentication in cloud providers. For example, with Azure: |
--mongodb-oidc-oidc-client-id globalArgs: {mongodb-oidc-oidc-client-id: "val"} liquibase.mongodb.oidc.oidcClientID LIQUIBASE_MONGODB_OIDC_OIDC_CLIENT_ID Read more: | String | Client ID of the User-Assigned Identity for OIDC authentication. |
--mongodb-retry-writes globalArgs: {retry-writes: "val"} liquibase.mongodb.retryWrites LIQUIBASE_MONGODB_RETRY_WRITES Read more: | Boolean | Specifies whether to retry write operations a single time after a failed write. If |
--mongodb-supports-validator globalArgs: {supports-validator: "val"} liquibase.mongodb.supportsValidator LIQUIBASE_MONGODB_SUPPORTS_VALIDATOR Read more: | Boolean | Specifies whether to create the Liquibase tracking collections with validators. Setting this parameter to |
Global report parameters
Syntax (--cli, {flow-file}, propertiesFile, ENV_VAR) | Type | Description |
| Boolean | Enables or disables all reports at the global level. Overridden by --report-enabled at the command level. Default: |
| String | Specifies the name of the report file at the global level. Overridden by --report-name at the command level. If you set a custom name, Liquibase overwrites the existing file every time you generate a new report. Default: |
| Boolean | Specifies whether to automatically open the report in your default browser at the global level. Overridden by --report-open at the command level. Default: |
| String | Specifies the file path to the report file at the global level. Overridden by --report-path at the command level. Default: |
| Boolean | Liquibase 4.31.0+. Specifies whether to hide exceptions (which may contain SQL) from operation reports at the global level. Overridden by --report-suppress-exception at the command level. Default: |
| Boolean | Liquibase 4.31.0+. Specifies whether to hide changeset SQL in operation reports at the global level. Overridden by --report-suppress-sql at the command level. Default: |
Mongo shell integration arguments
Syntax (--cli, {flow-file}, propertiesFile, ENV_VAR) | Type | Description |
| String | Defines extra arguments to pass to the mongosh executable. |
| String | Name of a custom executor you can specify. |
| Boolean | Indicates whether or not to keep a temporary SQL file after the execution of Mongosh. Default: false. |
| String | Indicates the name of a temporary SQL file after the execution of Mongosh. |
| String | Specify the path in which to store the temporary files after the execution of Mongosh. |
| String | Log file for Mongo shell output. |
| String | Path to mongosh executable. |
| Integer | Indicates seconds to wait for the mongosh timeout. -1 disables timeout. 0 returns error. Default: 1800 (30 minutes). |
Configuration
Syntax (propertiesFile, ENV_VAR) or (--cli, {flow-file}, propertiesFile, ENV_VAR) | Type | Description |
| String | The directory that points to the Liquibase installation location. |
| String | Enables the Liquibase debug mode, which produces more log output and allows the user to debug their database. |
liquibase.launcher.parent.classloader
| String | The classloader that runs Liquibase via either system or thread. Default: |
| String | [Deprecated] Specifies a default logging level. Default: |
| Boolean | [Deprecated] Defines whether Liquibase filters log messages for potentially insecure data. Default: |
| String | [Deprecated] Name of a custom executor you can specify. |
Command parameters
You can use command parameters with only certain commands or groups of commands.
Note: Syntax for each parameter is specified in kebab-case (CLI and flow file), camelCase (properties file and JAVA_OPTS), and MACRO_CASE (environment variable).
For best results, specify all commands and parameters in the --kebab-case format in the CLI. If your preference is camelCase, it also works in the CLI.
Note: It is best practice only to use alphanumeric characters and underscores in your liquibase-schema-name, because your database may not support hyphens and other special characters. If you must use hyphens, you must escape the lines containing hyphens. Many databases, such as PostgreSQL, MySQL, and SQLite support using quotes to escape characters. For example, "schemas-with-a-hyphen-or-dash-symbol-in-the-name". You'll need to refer to the documentation for your DBMS to determine if it supports quoted identifiers.
You do not need to use quoted identifiers if you are using objectQuotingStrategy="QUOTE_ALL_OBJECTS" at the changelog/changeset level.
Operation report parameters
Syntax (--cli, {flow-file}, propertiesFile, ENV_VAR) | Type | Description |
| String | Specifies the severity level of all error types in the drift report (changed, missing, or unexpected content). Valid values are INFO (0), MINOR (1), MAJOR (2), CRITICAL (3), and BLOCKER (4), from least severe to most severe. |
| String | Specifies the severity level of changed content in the drift report. Valid values are INFO (0), MINOR (1), MAJOR (2), CRITICAL (3), and BLOCKER (4). Overrides --drift-severity for changed content only. Default: INFO. |
| String | Specifies the severity level of missing content in the drift report. Valid values are INFO (0), MINOR (1), MAJOR (2), CRITICAL (3), and BLOCKER (4). Overrides --drift-severity for missing content only. Default: INFO. |
| String | Specifies the severity level of unexpected content in the drift report. Valid values are INFO (0), MINOR (1), MAJOR (2), CRITICAL (3), and BLOCKER (4). Overrides --drift-severity for unexpected content only. Default: INFO. |
| Boolean | If true, automatically opens the report in your default browser. Default: false. |
| Boolean | Enables a report at the command level. Overrides the global parameter --reports-enabled. Default: true. |
| String | Specifies the name of the report file at the command level. Overrides --reports-name. |
| String | Specifies the file path to the report file at the command level. Overrides --reports-path. Default: ./. |
| Boolean | Liquibase 4.31.0+. Specifies whether to hide exceptions from the operation report at the command level. Overrides --reports-suppress-exception. Default: false. |
| Boolean | Liquibase 4.31.0+. Specifies whether to hide changeset SQL in operation reports at the command level. Overrides --reports-suppress-sql. Default: false. |
General command parameters
Syntax (--cli, {flow-file}, propertiesFile, ENV_VAR) | Type | Description |
| Boolean | Liquibase Secure only. If true, creates a new DATABASECHANGELOG row for the tag. If false, adds the tag to the last existing row. Liquibase 4.23.1+. Default: |
| String | Fully-qualified class specifying ChangeExecListener. |
--change-exec-listener-properties-file
| String | Path to a properties file for ChangeExecListenerClass. |
| String | The author of the changeset. Supports * as a wildcard. |
| String | The changeset ID from the changelog. |
| String | Unique changeset tag in filepath::id::author format. |
| String | The path to the changelog containing the changeset to target. |
| String | Specifies the changeset contexts to match. |
| Integer | Specifies the number of changes to apply. |
| String | Directory to send loadData output CSV files generated by diff-changelog or generate-changelog. |
| String | The date and time to roll back to. Format: YYYY-MM-DD HH:MM:SS or YYYY-MM-DD'T'HH:MM:SS. |
| Boolean | If true, drops the DATABASECHANGELOGHISTORY table along with other database objects owned by the user. Liquibase 4.27.0+. Default: |
| String | Specifies which database type a changeset is to be used for. The keywords all and none are also available. |
| String | Name of the default catalog to use for the database connection. |
| String | Name of the default schema to use for the database connection. |
| String | Types of objects to compare. Comma-separated list (no spaces). |
| Boolean | If true, requires the user to specify --force to use the drop-all command. Liquibase 4.27.0+. Default: |
| String | Objects to exclude from diff. |
| Boolean | Liquibase Secure only. When --rollback-on-error=true, controls whether Liquibase rolls back partially invalid changesets. |
| Boolean | If true, the catalog will be included in generated changesets. Default: |
| String | Objects to include in diff. |
| Boolean | If true, the schema will be included in generated changesets. Default: |
| Boolean | Include the tablespace attribute in the changelog. Default: |
| String | Specifies the changeset labels to match. |
| String | The directory where database documentation is generated. |
| String | Replaces schemas in the output changelog. Comma-separated list; size must match --schemas. |
| Boolean | Determines whether generate-changelog can overwrite an existing changelog. Default: |
--reference-liquibase-catalog-name
| String | Reference database catalog to use for Liquibase objects. Liquibase 4.24.0+. |
--reference-liquibase-schema-name
| String | Reference database schema to use for Liquibase objects. Liquibase 4.24.0+. |
| String | Change Types for which Liquibase sets replaceIfExists="true". Liquibase 4.26.0+. |
| Boolean | Liquibase Secure only. If any changeset fails, stops and rolls back all changesets just deployed. Liquibase 4.18.0+. Default: |
| String | The path to the script to use to perform the rollback. |
| String | Change Types for which Liquibase sets runOnChange="true". Liquibase 4.26.0+. |
| String | Database schemas to include objects from. |
| String | Produces a summary list of changesets skipped and why. Valid values: OFF, SUMMARY, VERBOSE. Liquibase 4.24.0+. Default: |
| String | Output destination for the update summary. Valid values: LOG, CONSOLE, ALL. Liquibase 4.24.0+. |
| Boolean | If true, skips object sorting so objects are ordered as returned by your database. Liquibase 4.27.0+. |
| String | Controls which types of objects to include in the snapshot. Liquibase Secure 4.26.0+. |
| String | Output format for snapshot. Valid values: JSON, YAML, TXT. Default: |
| String | The SQL string to execute. |
| String | The file where SQL statements are stored. |
| String | The tag identifying which tagged changesets to evaluate. |
| String | Tag version when multiple instances exist. Valid values: NEWEST, OLDEST. |
| Boolean | Specifies the detail level of the command output. Default: |
Policy check parameters
Syntax (--cli, {flow-file}, propertiesFile, ENV_VAR) | Type | Description |
String | The Liquibase component to run checks against. Valid values: changelog, database. | |
Boolean | If true, changesets are evaluated after property substitution. Default: true. | |
| Boolean | Automatically enable new policy checks in liquibase.checks.conf when they are available. Default: |
| String | Allows automatic backup and updating of the liquibase.checks-settings.conf file when new policy checks are available. Default: |
--cache-changelog-file-contents
| Boolean | If true, sqlFile Change Type contents are cached in memory to improve performance. Default: |
| String | The changelog file against which you execute checks when running liquibase checks run. |
| String | Specifies whether policy checks run on ALL changesets or only PENDING changesets. Default: |
| String | The name of the check(s) to target. Comma-separated list; prefix with ! to exclude. |
| String | Allow changeset rollback code to be analyzed for compliance with policy checks. Default: |
| String | Only show checks in the specified status. Valid values: ENABLED, DISABLED, ALL. Default: |
| String | Specify which parts of the checks run output to show. Default: |
| String | If using a checks packages file, specify which packages to run as a comma-separated list. |
| Boolean | Allow execution of custom script checks. Default: |
| String | Only allow custom scripts from the specified directories to execute. |
| String | Specifies the checks settings file to use with policy checks commands. |
| Boolean | Disable all qualifying checks in the checks settings file. Default: |
| Boolean | Enable all qualifying checks in the checks settings file. Default: |
| Boolean | If true, Liquibase does not ask for confirmation when you run this command. Default: |
| String | Sets the format of the check output. Valid values: TXT, JSON. Default: |
| String | One or more comma-separated relative paths to checks settings files to bundle into the checks package. |
| String | The relative or fully qualified path and filename of the checks package YAML file to create. Default: |
| String | The name of the checks package object to create inside the checks package YAML file. |
| String | The schemas to check when --checks-scope contains database. |
| String | Set the severity return code (0–4) when the check is triggered. Default: |
| String | Only show the specified columns. Options: id, checkname, type, priority, shortname, scope, status, severity, customization, description, all. Default: |
| String | Severity returned when a check fails due to a SQL parse error. Values: 0 (INFO), 1 (MINOR), 2 (MAJOR), 3 (CRITICAL), 4 (BLOCKER). Defaults to the executed check's severity. |
| String | The JDBC database connection URL. |
Init parameters
Syntax (--cli, {flow-file}, propertiesFile, ENV_VAR) | Type | Description |
| Boolean | Recursively copy files from the source directory. Default: |
| String | Source directory where the project files will be copied from. Default: |
| String | Path to the directory where the project files will be created. |
| String | Relative or fully qualified path to the changelog file. Default: |
| String | Format of the project changelog file. Default: |
| Boolean | For remote project locations, do not delete temporary project files. Default: |
| String | Password to use to connect to the database. Default: |
| String | File with default Liquibase properties. Default: |
| String | An optional parameter used to specify the directory containing files (existing or to be auto-created) to be used with Liquibase. Default: |
| String | Turns on or off the CLI interactive mode. Default: |
| String | The JDBC database connection URL. Default: |
| String | Username to connect to the database. Default: |
| String | Network address to bind to. Default: |
| String | Port to run the h2 database on. Default: |
| Boolean | Whether to open a browser to the database's web interface. Default: |
| String | Password to use for the created h2 user. Default: |
| String | Username to create in h2. Default: |
| String | Port to run h2's web interface on. Default: |
Connection profile parameters
Syntax (--cli, {flow-file}, propertiesFile, ENV_VAR) | Type | Description |
String | Specifies the root changelog file to execute. | |
String | The JDBC driver class. | |
String | The JDBC driver properties file. | |
| String | Password to connect to the target database. |
--reference-default-catalog-name
| String | The reference default catalog name to use for the database connection. |
--reference-default-schema-name
| String | The reference default schema name to use for the database connection. |
| String | The JDBC driver class for the reference database. |
--reference-driver-properties-file
| String | The JDBC driver properties file for the reference database. |
| String | Password to connect to the reference database. |
| String | Comma-separated list of reference schemas to use in diff operations. |
| String | The JDBC connection URL for the reference database. |
| String | Username to connect to the reference database. |
| String | The JDBC connection URL for the target database. |
| String | Username to connect to the target database. |
Property substitution
Syntax | Description |
CLI only. Pass a name/value pair for substitution in the changelog(s). On Windows, surround the property name in quotation marks if it contains a dot. For example: |
Flow file parameters
Syntax (--cli, {flow-file}, propertiesFile, ENV_VAR) | Type | Description |
| String | The path to the configuration YAML file which contains one or more "stages" of commands to be executed in a liquibase flow operation. Default: |
| Boolean | If true, parse flow file YAML to allow only Liquibase flow file-specific properties, indentations, and structures. Default: |
| String | The default interpreter used to execute shell commands. Examples include bash, sh, and cmd. |
| Boolean | If true, do not delete temporary files created by the shell command execution. Default: |