We’re very completely satisfied to announce that you would be able to now use Liquibase’s open-source database devops library to handle and automate schema adjustments in Cloud Spanner.  The supply of Liquibase Cloud Spanner extension beta model 1.zero brings all of Liquibase’s CI/CD advantages to Spanner.

You could find the supply and detailed data in GitHub right here: cloudspannerecosystem/liquibase-spanner

Supported Options

The next change sorts are supported by the extension: createTable, dropTable, addColumn, modifyDataType, addNotNullConstraint, dropColumn, createIndex, dropIndex, addForeignKeyConstraint, dropForeignKeyConstraint, dropAllForeignKeyConstraints, addLookupTable, insert, replace, loadData, and loadUpdateData.

ChangeTypes are all examined as unit assessments, with the Spanner emulator, and with an actual Spanner.

Instance

An instance changelog.yaml is supplied that demonstrates a changelog utilized to Spanner. That is to assist apply Liquibase Best Practices utilizing Spanner.

It consists of the next:

To get began,  create a Cloud Spanner occasion in your GCP account or in a Spanner Qwiklab and check out the Liquibase extension

 



Leave a Reply

Your email address will not be published. Required fields are marked *