5.0 User guide
Get the most out of your tools. From everyday tasks to advanced workflows, the User guide shows you how to work efficiently and effectively with our platform.
Liquibase License Tracking
Enable Liquibase License Tracking
Produce the Liquibase Secure License Tracking Report
Changelogs
Formatted Mongo changelog example
Changesets
When should I use context and label attributes?
Liquibase concepts
What is property substitution?
How does Liquibase find files?
What is the liquibase.properties file?
What are Liquibase environment variables?
Use environment variables to control the amount of log information
What are environment variables in Docker?
What are JAVA_OPTS environment variables?
How does Liquibase handle data types?
How do I manage an offline database?
Assess logs to understand changelog efficiency
How do I include and exclude database objects?
Run the include-objects attribute
Run the exclude-objects attribute
Generate a changelog with diff-types
Diff multiple schemas in Liquibase
Generate SQL to update database schemas
How does Liquibase handle security?
What data does Liquibase collect and how is it used?
Liquibase Secure Developer VS Code extension
Install and configure the Liquibase Secure Developer VS Code Extension
Run commands in the Liquibase Secure Developer VS Code extension with the Command Palette
Run Liquibase Secure Developer commands with the Context menu
Tracking tables
What is the DATABASECHANGELOG table?
What is the DATABASECHANGELOGHISTORY table?
What is the DATABASECHANGELOGLOCK table?
Limitations
What are the COTS database limitations?
What are the memory limits on inspecting large schema?
CI/CD Workflows
Use GitHub actions with Liquibase
Rollback
Create custom rollback statements in Liquibase
What automatic rollbacks does Liquibase support?
Liquibase Flow files
Use Shell commands in Flow files
Native executors
Configure changesets to use native executors
What are the benefits of using native executors?
Best practices when using native executors
Observability
What is Liquibase Observability?
How do I enable operation reports?
Use drift reports in your CI/CD pipeline
What parameters can I use with operation reports?
Structured Logging
What are structured logging keys?
Analyze and use Structured log data
What is custom data in Structured logging?
Remote Files
What are the rules for remote file paths?
What are the rules for using search-path with remote files?
What Liquibase commands are used for remote files?
Secrets management
What are Liquibase Secrets management extensions?
What is the Liquibase HashiCorp Vault extension?
Use the Liquibase HashiCorp vault extension
Policy checks
Automatically create a snapshot and run checks
Manually create a snapshot and run checks
Filter the Checks table output
Use Git Bash with Policy checks
Create a new checks settings file
Create an additional checks settings file
Severity and exit codes in Policy check automation
Set policy check severity and exit codes
Verify naming conventions in your database
Troubleshooting your check chain
What are policy checks packages?
What are Policy check package paths?
Custom policy checks
What is a Liquibase Secure Custom policy check?
Configure a Custom policy check
Implement Liquibase Secure Custom policy checks
What are some examples of Custom policy check scripts?
What are Liquibase Python modules?
Write Dynamic Status Messages for Custom policy checks
What is Custom policy check property substitution?
Apply Property substitution in Custom policy checks
Set Up a Custom Python Virtual Environment for Liquibase Policy Checks
Use Custom Policy Checks with Docker
What default Policy checks does Liquibase offer?
What generic changelog policy checks does Liquibase offer?
Custom policy checks library
Collection Must Have Validator
Regex Custom policy checks library
MultipleCreateProceduresNotAllowed
MultipleCreateTablesNotAllowed
viewsMustHaveCreateReplaceViewOnly
Cassandra Regex Custom policy checks library
CreateTableMustHaveSystemKeyFile
DynamoDB Regex Custom policy checks library
DynamoDeleteGlobalSecondaryIndexCheck
MariaDB Regex Custom policy checks library
MongoDB Regex Custom policy checks library
Set the SEARCH_STRING to this valid regular expression:
Oracle Regex Custom policy checks library
CreateTableWithCertainColumnRequiresSequence
CreateTableWithCertainColumnRequiresTrigger
Snowflake Regex Custom policy checks library
CreateTableMustHaveDataRetention
SQL Server Regex Custom policy checks library
CreateProcedureMustHaveGrantExecute
NoDataDmlStatements for SQL Server
Changelog checks library
ChangesetAttributesSetTrueOrFalse
EndDelimiterExistsWhenPatternExists
Changelog database checks library
SQLServerFutureReservedKeywords