This article discusses the Storage Settings option for a database and how users can decide when to use it.
Functionality
This Storage Settings property controls whether or not storage options are collected for a specific database definition during the snapshot command. Storage Option information includes storage configuration, tablespace/filegroup assignments, large object storage parameters and partitioning information for tables and indexes.
If the Storage Options is set to “true”, Liquibase Enterprise will keep storage information in <ddb_project>/Resources/<schema>/storage.
Instructions
The Storage Settings option is located on the dbDef in the datical.project. By default the option is set to “false”. It can be updated by the following methods:
GUI checkbox for Storage Settings
Updating the datical.project file directly: storageOptionCollectedAtSnapshot="true"
Use Cases
If your database pipeline has different tablespace names across databases, you likely will want to keep Storage Settings set to “false”. With the setting set to true, Liquibase prepends tablespace names to items such as indexes during the convert packaging method. This means your script may work in REF but when deploying to databases with different tablespace names you may get Tablespace Not Found errors.