Liquibase forward engineering lets teams generate version-controlled changelogs directly from their SqlDBM models, closing the gap between design and automated deployment. The model stays as the single source of truth while Liquibase handles safe, incremental, git-connected rollouts of governed database change-management workflows.
This feature is currently available for the following projects due to intricacies in the syntax:
- Snowflake
Generating Liquibase scripts
Liquibase script generation is available on the Forward Engineering (FE) page for available projects. Just like existing FE capabilities, Liquibase supports both full Create and Alter (from pervious revisions) scripts.
The format is compatible with the latest Liquibase version.
Generating Full changelogs
On the Configuration step (1), select the "Full" option (default) to generate the entire project with all objects included. To generate the Full script from a previous revision, open that historic revision and do the same.
Once selected, press the "Generate Liquibase" button at the top to generate the script.
Generating diffs/alters
On the Configuration step (1), select the "Alter" option to generate the only the alters from a previous revision.
By default, the last revision is selected as the "from" candidate.
Note the settings from Configuration will affect the alter style. "Create" (default) will generate traditional alter scripts while "Create or Alter" will generate the full CREATE OR ALTER statement only for the modified objects between those revisions.
Once selected, press the "Generate Liquibase" button at the top to generate the script.
Pushing to git
Before pushing to git, ensure that a User Connection is selected in the project settings (see related article) with a valid git integration.
Once a full or alter script is generated, press the "Push to Git" button.
Optionally, configure the desired target folder for the generated YAML asset in the dropdown menu of the "Push to Git" button.
See also