Code | SQL Query | Programming

Managing Schema Changes On Cloud Spanner Using Liquibase

We’re very happy to announce that you can now use Liquibase’s open-source database devops library to manage and automate schema changes in Cloud Spanner.  The availability of Liquibase Cloud Spanner extension beta version 1.0 brings all of Liquibase’s CI/CD benefits to Spanner.

You can find the source and detailed information in GitHub here: cloudspannerecosystem/liquibase-spanner

Supported Features

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

ChangeTypes are all tested as unit tests, with the Spanner emulator, and with a real Spanner.


An example changelog.yaml is provided that demonstrates a changelog applied to Spanner. This is to help apply Liquibase Best Practices using Spanner.

It includes the following:

To get started,  create a Cloud Spanner instance in your GCP account or in a Spanner Qwiklab and try the Liquibase extension

By Mark Scannell(Strategic Cloud Engineer, Google Cloud) and Ron Pantofaro(Product Manager, Databases)
Source: Google Cloud Blog

For enquiries, product placements, sponsorships, and collaborations, connect with us at We'd love to hear from you!

Our humans need coffee too! Your support is highly appreciated, thank you!

Previous Article
Google Cloud | Cost Optimization

Protect Your Google Cloud Spending With Budgets

Next Article
Google Cloud

Application Modernization Isn’t Easy. But We Can Make It Easier.

Related Posts